How to Create Self Join MS Access
Here's how you can create a self-join in Access:
- Go to the 'Create' tab.
- Click 'Query Design'.
- Drag the Employees table into the query design window twice.
- Access automatically aliases the second instance as Employees_1.
- Create the join and drag the field from the first instance to the field of the second instance.
- In the query design grid, choose fields to display.
- Click 'Run' to execute the query.
This website uses cookies to ensure you get the best experience on our website. Learn More
Got it