[DRAFT]This page is not published. Only visible in development mode.
Join Transform
Use join to combine rows from two tables based on matching columns.
Inner Join
$ Inner Join
An inner join keeps only rows that have matches in both tables. Alias the joined table with as and specify the join condition with using.
Left Join
$ Left Join
A left join keeps all rows from the left table. Non-matching rows get none for the right-side columns.