Update. I have been looking into this too. I have confirmed that the data structures between the database that works and that doesn't are ditto. I have also removed the 2 table JOINs from the query and still the problem persists. So now I have one table only the main CTE table mItems, so right now I am concentrating on finding out which records differ and thus raising this problem.

One question. Can I quickly do a DELETE table between 2 FDBs?

Thanks and regards
Bhavbhuti