Join multiple tables and queries in a query

• In query Design view, drag a field from the field list for one table or query to the equivalent field (a field of the same or compatible data type containing similar data) in the field list for the other table or query.

  With this type of join, Microsoft Access selects records from both tables or queries only when the values in the joined fields are equal.

Notes  

• Join numeric fields only if the FieldSize property settings for both are Byte, Integer, or Long Integer.
  
  
• You can change the type of join so that Microsoft Access selects all the records from one table or query whether or not it has matching records in the other table or query. For more information, click .