Ok, this is making my head hurt. I've got a flat file that has campaign donation data from our local elected officials. I want to identify anyone who made a contribution to two officials. I want the users to be able to pick two officials and then run a select statement that will pull out all the people who have donated to both. I have tried unions, left outer, right outer, inner joins, etc. - nada.

I would like a result set that only has four columns official, contributor, date, amount. One of you SQL gurus who does this all day, every got any ideas?

Thanks,

John