How to Create Self Join MS Access

‍

‍

Here's how you can create a self-join in Access:

‍

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.