You can always create view:

create view VIEW1 as
SELECT .... blah blah blah
UNION
SELECT .... blah blah blah

Then there is nothing more simple than
select ... from VIEW1 order by Item1

Regards,

Marek

Uwe Oeder wrote:

>Is it somehow possible to order the the product of a union ?
>
>SELECT .... blah blah blah
>
>UNION
>
>SELECT .... blah blah blah
>
>ORDER BY Item1
>
>
>