To create an outer join

  1. Right-click the column name in the table that you want to be the main table of the outer join and select Add Outer Join from the context menu. The Specify Outer Join dialog box opens.

  2. Select the main table for the outer join.

  3. Select the join table for the outer join.

  4. If you want a full outer join, select the Also Retrieve All Records check box.

  5. Click OK. The Specify Criterion dialog box opens.

  6. Build the expression to determine which records should be retrieved in the join. How?   

  7. Click Finish. The Specify Expression dialog box closes, the column name on which the join depends changes to yellow, and the OUTER JOIN phrase is added to the statement.

See Also

Outer Joins

Performing Table Joins

Building Criteria