SQL ambiguous outer joins (I think the solution is easy)



I am trying to add a field from a new table to an an existing query that
already contains multiple fields from multiple tables that all share one
primary key and are linked by LEFT joins. By default, when I add the table to
my query, it is set up as an INNER join in the FROM clause. When I initially
try to save the query (before trying to change the join to a LEFT join), I
get the following message: "The SQL statement could not be executed because
it contains ambiguous outer joins. To force one of the joins to be performed
first, create a separate query that performs the first join and then include
that query in your SQL statement." If I go directly to the SQL statement in
try to change the INNER to a LEFT, I am told that the "Join expression is not
supported." The only way I can add fields after the query has been
established, is to start over and create the query again using the wizard.
I'm sure there is a way to add fields from new tables to my existing query so
that they are LEFT joins (so that I'm getting the records I want), but how?

OfficeDev18 via AccessMonster.com

It sounds to me like you've already set these tables up in the Relationships
screen with a one-to-one or one-to-many relationship, and trying to change it
for purposes of the query. If that's the case, you might want to undo the
relationship temporarily if you really need to put the table in the query as
a LEFT join.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question