selecting rows tagged with "a" but not "b"

Поиск
Список
Период
Сортировка
От 8q5tmkyqry@sneakemail.com
Тема selecting rows tagged with "a" but not "b"
Дата
Msg-id 11366-1265031099-334353@sneakemail.com
обсуждение
Ответы Re: selecting rows tagged with "a" but not "b"
Re: selecting rows tagged with "a" but not "b"
Re: selecting rows tagged with "a" but not "b"
Список pgsql-sql
Hi,

I have a two tables:

article
articleID, name, content

tags
articleID, tag

I want to find all articles that are tagged with "a" but not "b"

how do I do this?

what I'd like to do is:

<wishful thinking>
select articleID from tags where tag="a"
SUBTRACT
select articleID from tags where tab="b"
</wishful thinking>

how do I do this in real SQL?

thanks

Darrell


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