Received: from mail.ctcd.cc.tx.us (unknown [63.109.217.181]) by postgresql.org (Postfix) with ESMTP id 530DC475933 for ; Wed, 17 Apr 2002 12:50:35 -0400 (EDT) Received: from techlab01 ([10.139.129.20]) by mail.ctcd.cc.tx.us (8.9.3 (PHNE_22672)/8.9.3) with SMTP id LAA18850 for ; Wed, 17 Apr 2002 11:55:53 -0500 (CDT) Message-ID: <006d01c1e630$0b8356a0$14818b0a@ctcd.cc.tx.us> From: "Alexis Maldonado" To: Subject: SQL question.. Date: Wed, 17 Apr 2002 11:50:56 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_006A_01C1E606.228E54F0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Archive-Number: 200204/756 X-Sequence-Number: 23471 This is a multi-part message in MIME format. ------=_NextPart_000_006A_01C1E606.228E54F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I know this might be a dumb basic sql question but.. I have a query list of IDs ( 4,3,1,2,12,5,6,8,7,9,11) I want to build a query that gets those IDs in the exact same order but whe= n i do Select * From Table Where ID IN ( 4,3,1,2,12,5,6,8,7,9,11) It gets all the IDs in random order.. how can i get them in the order listed? Thanks, Alex ------=_NextPart_000_006A_01C1E606.228E54F0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
I know this might be a dumb basic sql question=20 but..
 
I have a query list of IDs (=20 4,3,1,2,12,5,6,8,7,9,11)
 
I want to build a query that gets those IDs in the exac= t same=20 order but when i do
 
Select * From Table
Where ID IN ( 4,3,1,2,12,5,6,8,7,9,11)
 
It gets all the IDs in random order..
 
how can i get them in the order listed?
 
Thanks,
Alex
------=_NextPart_000_006A_01C1E606.228E54F0--