[AccessD] deduplication

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




More information about the AccessD mailing list