Home Forums Article Discussions Article Discussions by Author Discuss content posted by Seth Delconte Get Rid of Duplicates! RE: Get Rid of Duplicates!

  • November 30, 2009 at 10:46 am

    #1085563

    I use this:

    DELETE FROM tblUser tu1

    WHERE tu1.intUserID > ANY (SELECT intUserID

    FROM tblUser tu2

    WHERE tu2.strUserName = tu1.strUserName

    AND tu2.strFamilyName = tu1.strFamilyName)