Share via

Change the type of join between tables and queries in a query

  • Article

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.

  1. Open a query in Design view.

  2. Double-click the join line between the field lists for the tables or queries.

    Double-click the join line to open the Join Properties dialog box

  3. In the Join Properties dialog box, click the join option you want, and then click OK.

Examples of different join types and how they affect query results

Notes  

  • From the Relationships window, you can change the default join type for tables. For more information, click aa201997(v=office.10).md.

  • All of the joins created using the Join Properties dialog box select records only if the values in the joined fields are equal. You can create joins that select records only if the value in one join field is greater than, less than, not equal to, greater than or equal to, or less than or equal to the value in the other join field; to do so, you must create an SQL statement in SQL view.