>Apparently my problem is that I don't have the right number of fields and/or the right types. What I am running into is the first SQL isn't looking at all the same files so I don't have the field names to reference or whatever I need to do to get them.
>
>Can someone explain this better than the online help and maybe give me a simple (yea right - is there such a thing with unions?) example or two?
>

Plus, any ORDER BY or GROUP BY clauses have to come at the end of the last select statement.

If you can issue the 2 select statements separately and come up with identical structures on the return cursors, then you can safely [usually] put a UNION between the 2 commands.