By default, for queries of two or more tables, Microsoft Access shows only those rows that have value matches in both tables.

Question

Quizplus · Accepted Answer

This is known as an inner join, where only rows with matching values in both tables are shown. Other types of joins (such as left join or right join) can be used to show all rows from one table even if there is not a matching value in the other table.

By Default, for Queries of Two or More Tables, Microsoft