Sergey,

Here is my select statement and it is giving me more elected officials than it should.

SELECT name,amount,official,date FROM cmoney WHERE name IN (SELECT name FROM cmoney ;
WHERE (official = ?Official1 or official = ?Official2 );
GROUP BY 1 HAVING COUNT(*) > 1)

I only want records which include (name) contributor who gave to both officials.

john doe,1/1/99,1000.00,A.Politician
john doe,12/4/98,500.00,B.Politician

Above is a simplification of how the result set should look.


Thanks,

John



>>
>>Try

>>SELECT * FROM Contributuions
>>	WHERE Contributor IN (
>>		SELECT Contributor FROM Contributuions
>>		WHERE official = @Official1 or official = @Official2
>>		GROUP BY 1
>>		HAVING COUNT(*) > 1
>>				)

>
>Somehow, I figured you'd be the one to come up with the answer within a few milliseconds!<g>
>
>Thanks Sergey!