In Access, you can reverse the tables and use a LEFT JOIN to achieve the same result. Here’s how to do it:
- Right-click on the query in the navigation pane and select 'SQL View'.
- Enter the SQL Query.
- Click on the 'Run' button to see the result.
In Access, you can reverse the tables and use a LEFT JOIN to achieve the same result. Here’s how to do it: