How to Use Right Join MS Access

‍

‍

In Access, you can reverse the tables and use a LEFT JOIN to achieve the same result. Here’s how to do it:

‍

1. Right-click on the query in the navigation pane and select 'SQL View'.
2. Enter the SQL Query.
3. Click on the 'Run' button to see the result.