JOIN Syntax
Combine data from one or more relations.
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;
Updated 6 months ago