Joining Tables
Queries to select data from more than one table
Join the tables based on matching fields in corresponding columns
In an Access query, a join line between matching fields in the two tables will be created indicating how the tables are related
When joining multiple tables
- Add all the tables involved to the upper pane
- Add the query results grid in the desired order