Create Join window

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.
Related tasks
Creating joins in the SQL builder

Feedback