Microsoft Office Tutorials and References
In Depth Information
Creating an additional query to resolve a problem with mixed joins
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.
1
Having created another query that joins together the tables we
removed (with the outer join), add this query to the query design.
2
2
Search JabSto ::




Custom Search