This interactive demo was created free with Storylane in 2 minutes. Create your own demo
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.
