Queries VIII: Dealing with 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.
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.