Thanks Rich,

I'm afraid I'm still getting more data returned than should be. Here's another look at the data.

name official date amount
ADAMS, J. KEVIN Mark Luttrell 3/20/2006 500
ADSTAFF LLC Mark Luttrell 5/28/2003 1000
AFSCME Rickey Peete 5/28/2003 250
AFSCME Rickey Peete 5/28/2003 300
AJDC, LLC Rickey Peete 2/14/2005 250
ARMSTONG ALLEN Mark Luttrell 2/14/2005 500
ARMSTONG ALLEN Rickey Peete 2001 500
ARMSTONG ALLEN Rickey Peete 2002 500
AUTOZONE INC. Mark Luttrell 7/18/2002 1000
AVIOTI, PETE Rickey Peete 5/1/2003 200
BAAB, BILLY Mark Luttrell 5/1/2003 1000
BAAB, BILLY Rickey Peete 5/1/2003 250


From this group, I should only return the following:

ARMSTONG ALLEN Mark Luttrell 2/14/2005 500
ARMSTONG ALLEN Rickey Peete 2001 500
ARMSTONG ALLEN Rickey Peete 2002 500
BAAB, BILLY Mark Luttrell 5/1/2003 1000
BAAB, BILLY Rickey Peete 5/1/2003 250

I need every instance of any contributor who has given to both candidates.

Even using a two step process, I get more results than I asked for:

SELECT name,official,date,amount FROM cmoney INTO CURSOR xxx WHERE official in (?o1,?o2)  ORDER BY name,official,date

SELECT name,amount,official,date FROM xxx;
 WHERE name IN (SELECT name FROM xxx;
                 GROUP BY name;
                 HAVING count(*) > 1) ORDER BY name,official,date

For a simple task, this is turning into a "head scratcher". I guess I could always just use the brute force method! Aaaarrrrrggghhhhh