Edit the join conditions
These steps are part of the larger task of joining tables in a SELECT statement. When you complete the steps for editing the
join conditions, return to Join tables in a SELECT statement.
To edit the join conditions:
- Select a join in the Joins area.
- In the Join conditions area, select a column from the
First column list, or click Expression... to open a window where you can
create an expression.
- Select an operator from the Operator list.
- Select a column from the Second column list. An icon (

) is displayed at the left side of the Join conditions field if the
join condition is invalid.
- Optional: Click Suggest to open a window where you can
select from a list of valid join paths.
Return to Join tables in a SELECT
statement.