Home > Sample chapters > Microsoft Office > Access

Selecting Data Using Queries in Microsoft Access 2013

Creating an additional query to resolve a problem with mixed joins

We have a query that links together Orders, Order Details, and Products. Because we want to also show any Orders without Order Details, the join from Orders to Order Details is set to an outer join to include all Orders with or without Order Details. The join to products has been left as a matching join. This mixture causes a join ambiguity problem.

In our example, we could change the join between Order Details and Products to an outer join, but we want to demonstrate the solution that is proposed by the text in the join ambiguity warning box, where the query is changed to use another query that contains the outer join between Orders and Order Details.

Resolve join ambiguity

  1. Click each of the tables where the join is different, and press Delete to remove the tables from the query.

  2. Having created another query that joins together the tables we removed (with the outer join), add this query to the query design.