Union query size limit?

  • Thread starter Thread starter Sirocco
  • Start date Start date
S

Sirocco

I have a Union query with 21 union clauses, each joined by "UNION", and it
works. But when I add a 22 clause, with the same alias as the other 21, I
get a "Not a valid alias name" error and the query doesn't run. Is there
a limit to the amount of text in a union query?

Thanks in advance.
 
I asked this question a few weeks ago... The answer is the
query when compiled cant be greater than 64k. It just so
happens at 22 with me it was 31. I had to break my query
into 2 queries.

Martin
 
Back
Top