Purpose

The SQL-92 left, right, and full outer join syntax is supported.

Syntax

 {oj outer-join}

where outer-join is

table-reference {LEFT | RIGHT | FULL} OUTER JOIN {table-reference | outer-join} ON search-condition

where table-reference is a database table name, and search-condition is the join condition you want to use for the tables.

For 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 outer join escape sequences are supported:

  • Left outer joins
  • Right outer joins
  • Full outer joins
  • Nested outer joins