> # Outer Join Escape Sequences

> ODBC supports the SQL92 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

> where `table-reference` is a table name, and `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 A-10 lists the outer join escape sequences supported by SequeLink for each data store.

> Table A-10. Outer Join Escape Sequences Supported
> Data Store | Outer Join Escape Sequences
> --- | ---
> DB2 on z/OS | Left outer joins Right outer joins Full outer joins Nested outer joins Inner outer joins
> DB2 on Windows and UNIX | Left outer joins Right outer joins Full outer joins Nested outer joins Unordered outer joins Inner outer joins
> Informix | Left outer joins Unordered outer joins
> Microsoft SQL Server | Left outer joins Right outer joins Full outer joins Nested outer joins