# How to Create Self Join MS Access

> To create a self join in MS Access, go to the Create tab, click Query Design, and drag the Employees table into the window twice to get the second instance aliased as Employees_1. Create the join by dragging a field from the first to the second instance, choose display fields in the grid, and click Run.

Canonical: https://livedemo.ai/tutorials/how-to-create-self-join-ms-access/
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3a22ab56e05a00fe1111/preview?step=1

## Steps

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.