Change the join type

These steps are part of the larger task of joining tables in a SELECT statement. When you complete the steps for changing the join type, return to Join tables in a SELECT statement

To change the join type:

  1. In the Join tables window, select a join in the Joins area.
  2. In the Details area, either select a join from the Join type list, or click Join Types to open a window where the different join types are described in detail. In the Join Type window:
    1. Select an option for the left table in the Left table field.
    2. Select an option for the right table in the Right table field. The resulting join type is described in the Join type field.
    3. Click OK. The Join Type window closes and the join type you specified is selected in the Join type list.

Return to Join tables in a SELECT statement