How to Create Self Join MS Access

Guide

1. Go to the 'Create' tab.

2. Click 'Query Design'.

3. Drag the Employees table into the query design window twice.

4. Access automatically aliases the second instance as Employees_1.

5. Create the join and drag the field from the first instance to the field of the second instance.

6. In the query design grid, choose fields to display.

7. Click 'Run' to execute the query.