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:
- In the Join tables window, select a join in the Joins
area.
- 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:
- Select an option for the left table in the Left table
field.
- Select an option for the right table in the Right table
field. The resulting join type is described in the Join type
field.
- 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