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.
This website uses cookies to ensure you get the best experience on our website. Learn More
Got it