[Skunkworks] MySQL QUERY TO FIND DUBLICATES IN DATABASE

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?