The topmost query in a series of queries, each connected by UNION ALL, dictates
the allocated space for data in each column for the resulting row set! This is
very bad - and makes the UNION useless.
Is there some database option that will make a UNION behave properly in mySQL?
See msg 135092 for sample script if you want to see a physical example.
__________________________________________________
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com