9.10.1.3.1 Join Operators

This topic describes different types of joins available in the data pipelines.

The following types of join operators are available:

• Inner Join: The Inner Join selects all rows from both participating tables as long as there is a match between the columns.
• Left Join: The Left Join returns all rows from the left table, with the matching rows in the right table.
• Right Join: The Right Join returns all rows from the right table, with the matching rows in the left table.
• Full Join: The Full Join combines the results of both the left and right outer joins and returns all rows from the tables on both sides.