|
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
Navigation:
[Reply to this message]
|