Use the Join page to join tables in an SQL statement. The Join page displays the columns of each table selected on the Tables page.
To request a join:
Select a column in one of the tables. The tables are displayed in the order that they are shown in the Selected tables list on the Tables page.
Select a column in another table.
If the columns have compatible data types, a grey line is displayed, connecting the columns, and the Join button is available.
If the columns do not have compatible data types, an error message is displayed in the status area at the bottom of the window.
Click Join to create the join.
By default, a join is assumed to be an inner join. You can also request other types of joins by clicking Join Type. The following types of joins are available:
Inner join. Joins only the rows where the values of the two columns match.
Left outer join. Joins rows where the values of the two columns match and any additional rows in the left table (as viewed in the Join page).
Right outer join. Joins rows where the values of the two columns match and any additional rows in the right table (as viewed in the Join page).
Full outer join. Joins all rows from both tables.
To request additional joins, repeat the previous steps.
To remove a join:
Select the joined columns, or navigate to the join that you want to remove by clicking > or <. A red line indicates the currently selected join. Other joins are indicated by blue lines.
Click Unjoin. The join line is removed.
Related information
Joins page - Fields and controls
Specifying the tables for an SQL statement
Specifying search conditions for rows
Grouping rows and specifying search conditions for groups
Remapping data to another SQL data type