Outer Join Escape Sequences
.NET 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'
The PSQL ADO.NET Data Provider supports the following outer join escape sequences as supported by PSQL 9.
x
and higher:
•
Left outer joins
•
Right outer joins
•
Full outer joins