How do I do this queyr?

Поиск
Список
Период
Сортировка
От pierre@desertmoon.com
Тема How do I do this queyr?
Дата
Msg-id 19990225204143.16870.qmail@desertmoon.com
обсуждение исходный текст
Список 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

В списке pgsql-sql по дате отправления:

Предыдущее
От: "Brett W. McCoy"
Дата:
Сообщение: Re: SQL92 standard conformance [was Re: [SQL] OUTER JOINS in 6.4.2?? Work around??
Следующее
От: budin
Дата:
Сообщение: ...