There can be only one ORDER BY clause per UNION at the end of select. It applies to the whole result set. Sorry about that.
Try to get each select to work separatelly and then join them with UNION ALL and change ORDER BY to
...
Order By 1
>I'm gettin an invalid Union clause error message. If I delete the order by in the first select then I get another error message stating there must be a order by element.
>
>
--sb--