Hi all,
I have a rather long query selecting items out of various unconnected areas of the DB. I have a working query including 20 UNIONs but when I add the 21st I am presented with a syntax error DB Errorcode=-201 (standard general syntax code)
each statement in isolation runs fine.
Have i hit a hard limit on number of union allowed? Or is this something i may be able to work around / reconfigure? Appreciate I'll probably be advised to write a better query but the data really is unconnected so I do not see a solution to get all the data onto a single report without using UNION.
Thankyou
I have a rather long query selecting items out of various unconnected areas of the DB. I have a working query including 20 UNIONs but when I add the 21st I am presented with a syntax error DB Errorcode=-201 (standard general syntax code)
each statement in isolation runs fine.
Have i hit a hard limit on number of union allowed? Or is this something i may be able to work around / reconfigure? Appreciate I'll probably be advised to write a better query but the data really is unconnected so I do not see a solution to get all the data onto a single report without using UNION.
Thankyou