How do I do this queyr?

From: pierre(at)desertmoon(dot)com
To: pgsql-sql(at)postgreSQL(dot)org
Subject: How do I do this queyr?
Date: 1999-02-25 20:41:43
Message-ID: 19990225204143.16870.qmail@desertmoon.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message Brett W. McCoy 1999-02-25 21:51:02 Re: SQL92 standard conformance [was Re: [SQL] OUTER JOINS in 6.4.2?? Work around??
Previous Message budin 1999-02-25 19:24:28