Hi,
I would like to append 2 simple query's result but they are ordered
completly different like :
select * from foo order by col1 asc
union
select * from foo2 order by col2 desc
how could I do this? When I use union I can't use order by clause. Is
there a way to tell "simply append bot results in given order?"
thanks
Frédéric Boucher
Ed(at)jetumele(dot)com