thanks chris that was very clear ...i  executed this successfully but affected 0 records??

there are definately duplicates

any ideas?

so do i need to creat t1 and t2 before i start?

DELETE FROM t1

FROM         customer t1 INNER JOIN

                          (SELECT     MIN(autoID) AS autoID, Email

                            FROM          customer

                            GROUP BY Email

                            HAVING      COUNT(*)...

hey chris thanks for your help ... i found the script ... just having a little trouble unbdrestanding the pseudo code - is t1 a tablew which i need to...