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.

[ 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;