Posted by frank m via SQLMonster.com on 07/12/05 18:57

Hi,

I can't make my mind up what the most efficient query is for the following
problem. My table contains records similar to this example:
ID CAT
1 A
1 B
2 A
3 A
3 B
I now want to extract all ids that have the CAT value 'A' and 'B' .
In this example the result would be 1,3.

What's the best way to do it? Any help is much appreciated!

Cheers, Frank

[Back to original message]