O'Reilly logo

Microsoft Access 2013 Inside Out by Jeff Conrad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required