Outer Join Escape Sequences
JDBC supports the SQL92 left, right, and full outer join syntax. The escape sequence for outer joins is:
{ojouter-join}table-reference {LEFT | RIGHT | FULL} OUTER JOIN {table-reference| outer-join} ONsearch-conditiontable-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'Table D-2 lists the outer join escape sequences supported by the Microsoft SQL Server 2000 Driver for JDBC.
Table D-2. Outer Join Escape Sequences Supported Data Store Outer Join Escape Sequences SQL Server 2000 Left outer joins
Right outer joins
Full outer joins
Nested outer joins
|
|
Previous Page |
|
Next Page |
|
Synchronize with Contents |