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