The JOIN component merges two tables by associating the columns in the tables and determines the output columns. This component works similarly to the JOIN statement of SQL.
|Join Type||The join type. Valid values: Left Join, Inner Join, Right Join, and Full Join.|
|Join Condition||The join conditions, which is in the format of equations. You can manually add or remove join conditions.|
|Columns Output by Left Join Table||The output columns you selected from the left table.|
|Columns Output by Right Join Table||The output columns you selected from the right table.|