try this... just remove the FIRST() SELECT table1.field1 AS field1Field, COUNT(table1.field1) AS NumberOfDups FROM table1 INNER JOIN table2 ON table1.field1 = table2.field1 GROUP BY table1.field1 HAVING NumberOfDups > 1 Steve ----- "The sherminator" <steve.kim41@gmail.com> wrote:
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?
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke