If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
The SQL statement could not be executed because it contains ambiguous outer joins.
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? |
#2
|
|||
|
|||
The SQL statement could not be executed because it contains ambigu
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. "quirkyjoe" wrote: 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? |
Thread Tools | |
Display Modes | |
|
|