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 [EMAIL PROTECTED]
