Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2013

    Unanswered: Union All Query: "Query is too complex?"

    Hello All! In need of your assistance once again

    I have a Union All QRY which currently joins 50+ Tables and recently have been getting an the error message "Query is too compltex." I realzie this is not the most efficient way to merge all the tables but is there a work around or another method I could use? Thanks!

  2. #2
    Join Date
    Mar 2009
    Provided Answers: 14
    Without knowing anything about the tables or the queries involved, it's hard to give any sensible advice. You could perhaps merge the data into a new table, but that remains to be tested.
    Have a nice day!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts