Although a simple answer, this is one of the most common questions for those new to Access – How do I add a table to an existing query?
Figure 38. Show Table Dialog Box
Adding a Table or Query to an Existing Query
1. Open the Query in Design View
2. Click the Show Table command in the Query Setup group on the Query Tools Design Contextual tab
3. Choose the Table(s)/Query(ies) to add to your query
4. Click Add
5. Click Close