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:

  1. Select a join in the Joins area.
  2. 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.
  3. Select an operator from the Operator list.
  4. 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.
  5. 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.