Create an outer join

Microsoft Query

Show All Show All

Create an outer join

An outer join displays all of the records from one table and any records from related records from another table.

  1. Create an inner join between the tables. How to create an inner join.
  2. Double-click the join line between the tables.
  3. Click = (equal sign) in the Operator list.
  4. Do one of the following:

    To create an outer join that uses all of the records from the table on the left, click option 2 under Join Includes.

    To create an outer join that uses all of the records from the table on the right, click option 3 under Join Includes.

Notes