Received: from mail.utexas.edu (wb3-a.mail.utexas.edu [128.83.126.138]) by postgresql.org (8.11.3/8.11.4) with SMTP id f7KGWWP82126 for ; Mon, 20 Aug 2001 12:32:32 -0400 (EDT) (envelope-from webmaster@robbyslaughter.com) Received: (qmail 15747 invoked by uid 0); 20 Aug 2001 16:32:31 -0000 Received: from adsl-64-218-161-124.dsl.austtx.swbell.net (HELO robmanbox) (64.218.161.124) by umbs-smtp-3 with SMTP; 20 Aug 2001 16:32:31 -0000 Reply-To: From: "Robby Slaughter" To: "Mark Mikulec" , Subject: RE: Sequential select queries...?? Date: Mon, 20 Aug 2001 11:35:00 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) Importance: Normal In-Reply-To: <3B79C512.9F6E09B7@badger.ac.brocku.ca> X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200108/247 X-Sequence-Number: 4482 >Hello, >At first I thought what I was trying to do was simple and could be done >easily - but alas, I've spent way too much time and could not figure out >how to get the results in question. I think there's cause for excitement, because unless I'm interpreting you incorrectly, it IS easy to do what you want to do: Use the UNION functionality. If your table T is this id name description ------------------------- 1 abc def 2 bcd abc 3 def ghi 4 jkl bcd 5 hij hij And you do this: SELECT id FROM T WHERE name = 'abc' UNION SELECT id FROM T WHERE desc = 'abc'; You'll get: id ---- 1 2 That ought to do it for you! Hope this helps, Robby Slaughter