Query Wizard: Step 2a – Include Records
Limit your query by choosing only matching rows from both tables or all rows from either table. By default, only matching records are included.
If you want to create an inner join, select Only matching rows. If you want to create an outer join, select all the records from one of the two tables.
See Also
Cross-Tab Wizard | Graph Wizard | Local View Wizard | Query Wizard: Step 1 - Select Fields | Query Wizard: Step 2 - Relate Tables | Query Wizard: Step 3 - Filter Records | Query Wizard: Step 4 - Sort Records | Query Wizard: Step 4a - Limit Records | Query Wizard: Step 5 - Finish | Remote View Wizard | Query Wizard