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 the inner join type currently. Other join types such as left, right, full, and cross/cartesian are not yet supported.
[ INNER ] 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;
Updated about 2 months ago