Use this window to specify a join condition to join two tables.
A join is a relational operation that you can use in a SELECT
statement to retrieve data from two or more tables. The data that is retrieved
is based on the join condition that you specify.
- Source
- Table (alias)
- Select the source table for the join condition.
- Column
- Select the source column that you want to use
to create the join.
- Source column type
- Shows the data type of the selected source column.
- Target
- Table (alias)
- Select the target table that you want to join
with the source table.
- Column
- Select the target column that you want to use
to create the join. For the join condition to be true, the target column
must have the same value as the source column.
- Target column type
- Shows the data type of the selected target column. The
data type of the target column must match the data type of the source column.
- Join type
- Select the option for the rows that you want in
the results table.
- Inner join
- This option combines every row of the source table
with every row of the target table, keeping only the rows where the join condition
is true.
- Left outer join
- This option includes the rows from the source
table that are missing in the inner join.
- Right outer join
- This option includes the rows from the target
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.