JOIN Syntax

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;