Local View Wizard: Step 2a – Include Records

  • Article

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 of the rows from one of the tables.

See Also

Cross-Tab Wizard | Graph Wizard | Local View Wizard: Step 1 - Select Fields | Local View Wizard: Step 2 - Relate Tables | Local View Wizard: Step 3 - Filter Records | Local View Wizard: Step 4 - Sort Records | Local View Wizard: Step 4a - Limit Records | Local View Wizard: Step 5 - Finish | Query Wizard | Remote View Wizard | Wizards Overview | Local View Wizard