JDBC supports the SQL92 left, right, and full outer join syntax.
Syntax
{oj table-reference {LEFT | RIGHT | FULL} OUTER JOIN {table-reference | outer-join} ON search-condition}
where:
table-reference
is a 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'
