Received: from desertmoon.com (qmailr@desertmoon.com [198.182.124.2]) by hub.org (8.9.2/8.9.1) with SMTP id PAA34742 for ; Thu, 25 Feb 1999 15:35:20 -0500 (EST) (envelope-from pierre@desertmoon.com) From: pierre@desertmoon.com Received: (qmail 16871 invoked by uid 100); 25 Feb 1999 20:41:44 -0000 Message-ID: <19990225204143.16870.qmail@desertmoon.com> Subject: How do I do this queyr? To: pgsql-sql@postgreSQL.org Date: Thu, 25 Feb 1999 13:41:43 -0700 (MST) X-Mailer: ELM [version 2.4 PL25] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit All, Given a table of keywords. How would I grab the distinct id's that have both keywords attached to it. Example: ID | Keyword ------------- 1 | abc 2 | abc 3 | def 1 | def We want all the id's that have BOTH abc AND def as keywords. I think I may be having a brain freeze here...it seems obvious but I just can't seem to get my brain to spit up the answer. :( Too much caffiene? Thanks for the help! -=pierre