Selecting data from multiple tables
At this point, you’ve been through all the variations on a single theme—queries on a single table. However, for many tasks, you’ll need to build a query on multiple tables or queries (yes, you can build a query on a query!), calculate totals, and add parameters. It’s easy to build on the knowledge of single table queries to retrieve related information from many tables and to place that information in a single query datasheet. You’ll find this ability to select data from multiple tables very useful in designing views for your web app user interface.
Creating inner joins
A join is the link you need to define between two related tables in a query so that the data you see makes sense. If you don’t define the link, ...