Show All

Change the type of join in a query (MDB)

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

   

   Join line

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

Note  From the Relationships window, you can change the default join type for tables.