The SQL statement could not be executed because it contains ambiguous outer joins.

[quirkyjoe]

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. (Error 3258)

Hi,

I had a nice query that was working off of two tables just fine. Call
them Table 1 and Table 2.

I added a field to Table 2 call "Unit". I did this so that I could
then add a third table - Table 3 - to the query and link Table 3 to
TAble 2 using the "Unit" field.

However now when I run my query with Tables 1, 2, and 3 included I get
the error message above.

Any idea what is going on?

 

[Damian S]

Hi quirkyjoe,

You get that error when Access can't work out which joins need to be applied
first... in a simple scenario, it usually means you have an inner join and a
left join and a right join in the wrong sequence, making Access confused. If
you have simple joins (table1 joins to table2, table2 joins to table3) make
sure they are all inner joins, or if they are left joins, that the arrows all
point the same direction.

If you "need" to have them joining in a different fashion, join two tables
in a query then join the third table to the query.

Hope that helps.

Damian.