In Microsoft Access, an Outer Join retrieves rows from one table even if there is no matching data in the related table. Here’s how to do it:
- Go to the 'Create' tab in the ribbon.
- Click 'Query Design'.
- Select the tables you want to join from the list and click 'Add Selected Tables'.
- Drag the field from one table to the related field in the other table. This creates a join line between the tables.
- Right-click the join line between the tables and select 'Join Properties'.
- Select the option for 'Include ALL records from the left table and only those records from the right table where the joined fields are equal'.
- Click 'OK' to proceed.
- Drag the fields you want to display into the query grid.
- Click the 'Run' button to see the results.
