Received: from cti13.citenet.net (cti13.citenet.net [206.123.38.75]) by hub.org (8.10.1/8.10.1) with ESMTP id e5LEoO177543 for ; Wed, 21 Jun 2000 10:50:24 -0400 (EDT) Received: from zack (g92-180.citenet.net [209.41.140.180]) by cti13.citenet.net (8.9.3/8.9.1) with SMTP id KAA67961 for ; Wed, 21 Jun 2000 10:49:42 -0400 (EDT) From: "Ed" To: "pgsql sql" Subject: Simply append... Date: Wed, 21 Jun 2000 10:49:38 -0400 Message-ID: <001f01bfdb8f$ec4c68a0$b48c29d1@citenet.net> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-Archive-Number: 200006/189 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@jetumele.com