skip to main content
SQL escape sequences for JDBC : Outer join escape sequences
  

Try DataDirect Drivers Now

Outer join escape sequences

JDBC supports the SQL-92 left, right, and full outer join syntax. The escape sequence for outer joins is:
{oj outer-join}
where:
outer-join
is table-reference {LEFT | RIGHT | FULL} OUTER JOIN {table-reference | outer-join} ON search-condition
table-reference
is a database table name.
search-condition
is the join condition you want to use for the tables.
Example:
SELECT Customers.CustID, Customers.Name, Orders.OrderID, Orders.Status
   FROM {oj Customers LEFT OUTER JOIN
      Orders ON Customers.CustID=Orders.CustID}
   WHERE Orders.Status='OPEN'
Note: The ON clause in a join expression must evaluate to a true or false value.
Table 9. Outer Join Escape Sequences Supported
Driver
Outer Join Escape Sequences
Apache Cassandra
Left outer joins
Right outer joins
Full outer joins
Nested outer joins
Apache Hive
Left outer joins
Right outer joins
Full outer joins
Apache Spark SQL
Left outer joins
Right outer joins
Full outer joins
Autonomous REST Connector
Left outer joins
Right outer joins
Full outer joins
Nested outer joins
Jira
Left outer joins
Right outer joins
Full outer joins
Nested outer joins
MongoDB
Left outer joins
Right outer joins
Full outer joins
Nested outer joins
Oracle
Left outer joins
Right outer joins
Full outer joins
Nested outer joins
Oracle Eloqua
Left outer joins
Right outer joins
Full outer joins
Nested outer joins
Oracle Sales Cloud
Left outer joins
Right outer joins
Full outer joins
Nested outer joins
Salesforce
Left outer joins
Right outer joins
Nested outer joins
SQL Server
Left outer joins
Right outer joins
Full outer joins
Nested outer joins