This interactive demo was created free with Storylane in 2 minutes. Create your own demo
How to Use Inner Join MS Access
Using an INNER JOIN in Microsoft Access allows you to retrieve only the rows where there is a matching value in both tables based on the specified relationship. This is one of the most common types of joins for combining related data. 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 the first table (left table) to the related field in the second table (right table). This creates a join line between the tables.
By default, Access creates an 'INNER JOIN' unless you change it in the join properties. Click 'OK'.
Click the 'Run' button to execute the query and view the results.
Drag the fields you want to include in your query into the query grid.
That's it! You have successfully used inner join in MS Access.
