Join multiple tables and queries in a query

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

• 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 aa830991(v=office.10).md.