>Hi John,
>
>Yes, I realized that you get all contributions for people who made donations to those 2 officials. You've to add the same where clause to the main select
>
>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) ;
> AND official = ?Official1 or official = ?Official2
>
>
>
It's still not happening. I'm getting all results from both officials.
name amount official date
ABC-ED PAC 5000 Mark Luttrell 3/24/2006
AC WHARTON FOR 500 Mark Luttrell 5/21/2004
ADAMS, J. KEVIN 500 Mark Luttrell 3/20/2006
ADSTAFF LLC 1000 Mark Luttrell 5/28/2003
AFSCME 250 Rickey Peete
AFSCME 250 Rickey Peete
AFSCME 300 Rickey Peete
ALLEN, JUDY C. 500 Mark Luttrell 7/11/2002
ALLEN, MARILYN 500 Mark Luttrell 1/12/2006
ALLEN, SCHELIA 500 Mark Luttrell 5/11/2004
ALLEN, WILLIAM 500 Mark Luttrell 3/17/2005
ALMOND, BARBAR 1000 Mark Luttrell 7/23/2002
The results should only show if the leftmost column contributed to both Luttrell and Peete. I'm getting all.
John
>>
>>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.
>>
>>
John Harvey
Shelbynet.com
"I'm addicted to placebos. I could quit, but it wouldn't matter." Stephen Wright