JOIN Syntax

The JOIN syntax is used to compare and combine data from multiple relations. The join_type supports only inner and left outer join types. Other join types such as right, full, and cross/cartesian are not supported.

[ INNER ] JOIN
LEFT [ OUTER ] JOIN

Examples

SELECT "orders-view".o_orderkey,"customer-view".c_name from "orders-view" 
inner join "customer-view" on "orders-view".o_custkey="customer-view".c_custkey limit 20;

SELECT {columns,...} FROM <t1> LEFT JOIN <t2> ON <t2>.n = <t1>.n

SELECT fieldName1table1, fieldName1table2, fieldName2table2 FROM 
tableName1, tableName2 WHERE fieldName2table1 = fieldName3table2 AND fieldName1table2 > 1000;