A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old March 6th, 2007, 10:47 PM posted to microsoft.public.access.gettingstarted
quirkyjoe
external usenet poster
 
Posts: 20
Default 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  
Old March 7th, 2007, 12:33 AM posted to microsoft.public.access.gettingstarted
Damian S
external usenet poster
 
Posts: 741
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:39 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.