Cross Reference Help

[Kerry Wilson]

I have a cross reference table with two ids like such:

mappings
dealerId -> int
categoryId -> int

is there any way to quickly select all dealerIds that appear in all the specified categories. Something like this:

SELECT dealerId WHERE categoryId IN ( 14,64,23 ) GROUP BY dealerId

Except, above will return all dealerId's that appear in any category instead of all categories.

Thanks