>Well,
>
>I performed a HACKUP job on my SELECT statements and got down to these 2 fields in each select. Can someone tell me WHY I am still getting a UNION incompatible error? What am I doing wrong!!!!!
>
>Thanks
Why don't you try breaking this up into a two or more selects, and building your results manually with APPEND FROM?
I haven't even looked at your select statement for longer than it takes to see it's a mess. I never use single statements like this when I could use more than one, because of the exact pains you are experiencing.
Erik Moore
Clientelligence