Page 5 of 13PREVNEXT

Queries VII: Query multiple sources for data

Inner joins return only matching data from the sources on both sides of the join

Inner joins find matching records.

You can use several types of joins in your queries. The most common is an inner join or equi-join.

An inner join returns data from one source only when it finds matching records in the other. For example, if you query for information about products and orders, you only see data for products that have a matching order, and the picture shows this. Most of the time, you don't need to do anything to create an inner join. Access uses them automatically whenever you create a table relationship or add a join to a query.

Page 5 of 13PREVNEXT