Message "Query too complex"

[Pettor]

Hi All,

I am trying to combine two queries (PRO3 & PRO4) that will update a table (PRO_TBL) but I am receiving the message "Query too complex". Can someone figure out what it might be?


INSERT INTO PRO_TBL ( ID, MDATE )
SELECT PRO3.ID, PRO4.MDATE
FROM PRO3 INNER JOIN PRO4 ON PRO3.ID = PRO4.ID;

Thanks

 

[Micron]

I think you are missing a table reference. Maybe try
INSERT INTO PRO_TBL ( ID, MDATE )
SELECT PRO3.ID, PRO4.MDATE
FROM PRO3, PRO4 INNER JOIN PRO4 ON PRO3.ID = PRO4.ID;
You should always test suggestions on copies of the tables or other objects.

 

[Pettor]

Thank you Micron,

I will test your suggestion but I have some doubts about the outcome. Most probably the problem occurs because in reality there are no tables "PRO3" & "PRO4". It is a mistake probably due to the MS Access graphical environment that creates the SQL code.
I have create a new thread describing the situation. Maybe in this way is more clear.

Thanks!

 

[xenou]

Where is the other thread you've created?

Nevermind, its here:
http://www.mrexcel.com/forum/microsoft-access/975725-help-append-query.html

Closing this thread.