Too many fields defined???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have some very lengthy and complex queries I am running that has about 45 columns in it, and once I'm done with the subqueries, I am using a UNION ALL statement to join them together. The problem I am running into is that while each of the three main subqueries will run individually, the whole query gives me the message Too many fields define. I can't find anything in the help. Is there some parameter/property I can set to get this to work as a union.

TIA

Mark
 
Mark

If the error message is to be believed, you have too much to hold in one
query statement. Does your UNION query work if you include fewer columns?
 
Back
Top