Re: SQL query to return all matching condition

[Roland Bouman]

Ok, I think i misread your original question. Sorry about that.

This should work:

SELECT name, category
FROM contact c
WHERE exists (
select null
from contact cat1
where cat1.name = c.name
and cat1.category = 'cat1'
)
and exists (
select null
from contact cat2
where cat2.name = c.name
and cat2.category = 'cat2'
)

That is, all rows for which there is one row in category 1
and one row in category 2