Gustav Brock
gustav at cactus.dk
Mon May 28 17:33:47 CDT 2007
Hi John OK. Then this should work: DELETE * FROM tblData WHERE PKID NOT IN (SELECT TOP 1 PKID FROM tblData As T1 WHERE T1.HashFamily = tblData.HashFamily ORDER BY T1.PKID); Still air code ... /gustav