skip to main content
SQL Escape Sequences for JDBC : Outer Join Escape Sequences
  
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'
The following table lists the outer join escape sequences supported by the drivers for each data store.
Table 35. Outer Join Escape Sequences Supported
Data Store
Outer Join Escape Sequences
DB2
Left outer joins
Right outer joins
Full outer joins
Nested outer joins
Informix
Left outer joins
Right outer joins
Full outer joins
Nested outer joins
MySQL
Left outer joins
Right outer joins
Nested outer joins
Oracle
Left outer joins
Right outer joins
Full outer joins
Nested outer joins
PostgreSQL
Left outer joins
Right outer joins
Full outer joins
Nested outer joins
Progress OpenEdge
Left outer joins
Nested outer joins
SQL Server
Left outer joins
Right outer joins
Full outer joins
Nested outer joins
Sybase
Left outer joins
Right outer joins
Nested outer joins
Apache Hive
Left outer joins
Right outer joins
Full outer joins
Greenplum
Left outer joins
Right outer joins
Full outer joins
Nested outer joins
Salesforce
Left outer joins
Right outer joins
Nested outer joins