Queries VIII: Dealing with ambiguous joins

Learn how to work around ambiguous joins

Learn how to resolve ambiguous outer joins. When you build a multi-source query, you sometimes get an error message that says you have an "ambiguous outer join." This course explains that type of join, and how to build queries that work around it.

Start course button

About this course

This course includes:

  • One practice session for hands-on experience. The practice requires Access 2007.

  • A Quick Reference Card you can take away from the course.


After completing this course you will be able to:

  • Create queries that work around ambiguous outer joins.

  • Build queries that use two or more queries as data sources.

Before you begin

Before you take this course, you need to understand joins, as well as base and secondary tables. You also need to know how to create multi-source queries in Access 2007. If you don't, first take the course listed in the prerequisites, and then come back to this course.

Topics in this course

  1. Work around ambiguous outer joins

  2. What makes a join ambiguous?

  3. Create the initial query

  4. Create the final query

  5. Practice

  6. Quick reference card

Applies To: Access 2007

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language