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.
Currently INNER JOIN
is optimized for queries that are time-bound and where at least one of the source views is at a small scale (e.g., a join between a log source over a 1-hour period and a reference table).
[ 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 2 months ago