How to Use Left Join MS Access
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 left table (primary table) to the related field in the right table (secondary table). This creates a join line between the tables.
- Right-click the join line between the tables and select 'Join Properties'.
- Select the option for 'Include ALL records from [Left Table] and only those records from [Right Table] where the joined fields are equal'.
- Click 'OK' to proceed.
- Drag the fields you want to display into the query grid.
- Click the 'Run' button to see the results.
This website uses cookies to ensure you get the best experience on our website. Learn More
Got it