MS Access: Add tables to a query in Access 2007
Question: In Microsoft Access 2007, I've created a query and I want to add another table to the existing query. How do I do this?
Answer: To do this, open the query in Design view. Select the Design tab in the toolbar at the top of the screen. Then click on the Show Table button in the Query Setup group.
When the Show Table window appears, highlight the table that you want to add and click on the Add button. When you are done selecting the tables, click on the Close button.
In this example, we want to add the Order Details table.
You should now see the Order Details table appear in the Query window.