Combine two tables based on common field
Join allows for the combination of two datasets into a single table, based on a shared column.
Left Table - any table
Right Table - any table
Single table with merged data from Left Table and Right Table
Column in the Left table that shares values with the Right table
Column in the Right table that shares values with the Left table
Indicates how the table should be joined. Includes the following options:
By default, joins create new rows for each match found in between the Left and Right tables. This often results in a joined table with many more rows than either source table. To prevent that, for a Left or Right join you can choose to only match the first or last matched record, rather than creating a new record for each match.