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

1. Open a query in Design view.
   
   
2. Double-click the join line between the field lists for the tables or queries.

   

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 .
  
  
• 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.