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
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