Show All

Change the type of join between tables in a query

1. Double-click the join line between the tables.
2. To select an operator that Microsoft Query will use to compare the data in the joined fields, click the operator you want in the Operator box. For more information, click .
3. To create an outer join that uses all of the records from the table on the left, click option 2 under Join Includes. You must select the = operator to create outer joins.

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

   To create an inner join that uses only records in both tables, click option 1 under Join Includes.

4. Click Add.
5. Click Close.

   For more information about join types and how they affect the results of a query, click .