Outer join escape sequences
- Last Updated: June 27, 2025
- 1 minute read
- DataDirect Connectors
- JDBC
- Aha! 6.0
- Amazon Redshift 6.0
- Apache Cassandra 6.0
- Apache Hive 6.0
- Apache Spark SQL 6.0
- Atlassian Jira 6.0
- Autonomous REST Connector 6.0
- Cloudera Impala 5.1
- + 24
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 | RIGHT | FULL} OUTER JOIN {table-reference | outer-join} ON search-condition - table-reference
- is a database 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'ON clause in a join expression must evaluate to a true or false value. | Driver | Outer Join Escape Sequences |
|---|---|
| Aha! |
Left outer joins Right outer joins Full outer joins Nested outer joins |
| Amazon Redshift |
Left outer joins Right outer joins Full outer joins |
| Apache Cassandra |
Left outer joins Right outer joins Full outer joins Nested outer joins |
| Apache Hive |
Left outer joins Right outer joins Full outer joins |
| Apache Impala |
Left outer joins Right outer joins Full outer joins Nested outer joins |
| Apache Spark SQL |
Left outer joins Right outer joins Full outer joins |
| Autonomous REST Connector |
Left outer joins Right outer joins Full outer joins Nested outer joins |
| DB2 |
Left outer joins Right outer joins Full outer joins Nested outer joins |
| Denodo |
Left outer joins Right outer joins Full outer joins Nested outer joins |
| GitHub |
Left outer joins Right outer joins Full outer joins Nested outer joins |
| Google Analytics 4 |
Left outer joins Right outer joins Full outer joins Nested outer joins |
| Google BigQuery |
Left outer joins Right outer joins Full outer joins Nested outer joins |
| Greenplum |
Left outer joins Right outer joins Full outer joins Nested outer joins |
| HubSpot |
Left outer joins Right outer joins Full outer joins Nested outer joins |
| Informix |
Left outer joins Right outer joins Full outer joins Nested outer joins |
| Jira |
Left outer joins Right outer joins Full outer joins Nested outer joins |
| Microsoft Dynamics 365 | Left outer joins Right outer joins Full outer joins Nested outer joins |
| Microsoft SharePoint | Left outer joins Right outer joins Full outer joins Nested outer joins |
| MongoDB |
Left outer joins Right outer joins Full outer joins Nested outer joins |
| MySQL |
Left outer joins Right outer joins Nested outer joins |
| Oracle |
Left outer joins Right outer joins Full outer joins Nested outer joins |
| Oracle Eloqua |
Left outer joins Right outer joins Full outer joins Nested outer joins |
| Oracle Sales Cloud |
Left outer joins Right outer joins Full outer joins Nested outer joins |
| Oracle Service Cloud |
Left outer joins Right outer joins Nested outer joins |
| PostgreSQL |
Left outer joins Right outer joins Full outer joins Nested outer joins |
| Progress OpenEdge |
Left outer joins Nested outer joins |
| Salesforce |
Left outer joins Right outer joins Nested outer joins |
| SAP HANA | Left outer joins Right outer joins Full outer joins Nested outer joins |
| SAP S/4HANA | Left outer joins Right outer joins Full outer joins Nested outer joins |
| Snowflake | Left outer joins Right outer joins Full outer joins Nested outer joins |
| SQL Server |
Left outer joins Right outer joins Full outer joins Nested outer joins |
| Sybase |
Left outer joins Right outer joins Nested outer joins |
| TeamCity |
Left outer joins Right outer joins Full outer joins Nested outer joins |