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

• Retrieve all records from two tables   If you want to combine all of the records from two tables, whether or not the records are related, you can create a full outer join.
• Retrieve only the records that two tables don't have in common   Instead of retrieving related records, you can retrieve all records that two tables don’t have in common.