skip to main content
Supported SQL and Extensions : Oracle Eloqua, HubSpot, and Marketo : Select : From Clause : Outer Join Escape Sequences

Try DataDirect Cloud Now
Outer Join Escape Sequences
JDBC supports the SQL-92 left, right, and full outer join syntax. The escape sequence for outer joins is:
{oj outer-join}
where outer-join is
table-reference {LEFT } 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.
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 by Oracle Eloqua, HubSpot, and Marketo data stores:
*Left outer joins