Specify Join window

Use this window to select the join type for the rows that you want in the results table.
Inner join
This option combines every row of the first table with every row of the second table, keeping only the rows where the join condition is true. The join condition is true when the column value in the first table is the same as the column value in the second table.
Left outer join
This option includes the rows from the first table that are missing in the inner join.
Right outer join
This option includes the rows from the second table that are missing in the inner join.
Full outer join
This option includes the rows from both tables that are missing from the inner join.
Related tasks
Creating joins in the SQL builder

Feedback