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.