Re: Problem with "Find Duplicates" using subquery

[Michael Berkowitz]

Well,

I found that I could get the results I want by using the following query:

SELECT Donations.* FROM Donations inner join
(select * from Donations group by date,amt,donor having count(*)>1) as temp
on Donations.date = temp.date and Donations.amt = temp.amt and Donations.donor = temp.donor

I'm guessing the key is to give the table generated by the subquery a name, since the engine probably doesn't like using the same table name in both the inner and outer queries.

Still, one would think that it would either reject the query with a syntax error or process it correctly.

Michael