Create an inner join
- Drag a field from one table to the equivalent field (a field of the same data type that contains similar data) in the field list for the other table.
Note With an inner join, Microsoft Query selects records from both tables or queries only when the values in the joined fields are equal. You can also create an outer join that retrieves all of the records from one table and any records from related records from another table.