Hi, All

I have a query in MsAccess to find duplicates which works fine. the statement is as follows:

SELECT First(table1.field1) AS field1Field, Count(table1.field1) AS NumberOfDups
FROM table1 INNER JOIN table2 ON table1.field1 = table2.field1
GROUP BY table1.field1 HAVING (((Count(table1.field1))>1))

I want to now use this statement in MySQL, but it has a problem with the syntax (most probable it does not understand the statements first and count)

Could you maybe give me an alternative statement?