Re: problem union and order by

[Uwe Geercken]

ok. I found the trick that does it: instead of ordering the second query (which does ot work), I have added a field "ordinal" and then I order the whole result first by the ordinal and then the airline name.

(
select '[All]' as airline_name,0 as ordinal
)
union
(
select
distinct airline_name,1 as ordinal
from
staging_final
)
order by ordinal, airline_name