Add a table or query to a query

1. Open a query in Design view.
   
   
2. On the toolbar, click Show Table .
   
   
3. In the Show Table dialog box, click the tab that lists the objects whose data you want to work with. If the table you need is in another database or application, first link the table to the active database.

   How?

4. Click the name of the object you want to add to the query. To select additional objects one at a time, hold down CTRL while you click each object name. To select a block of objects, click the first name in the block, hold down SHIFT, and then click the last name in the block.
   
   
5. Click Add, and then click Close.

Notes  

• You can also add a table or query to a query by dragging the table or query name from the Database window to the upper part of query Design view.
  
  
• When you have multiple tables or queries in a query, they need to be joined together. For information on joining tables, click .