Thread: How do I do this queyr?

How do I do this queyr?

From
pierre@desertmoon.com
Date:
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