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.