• Many thanks for both suggestions, as well. I, too, found Rajat's easier to understand and it worked correctly as:

    DELETE a

    FROM "dbo"."DM_ConformedPerson" a

    JOIN "dbo"."TST_Fix_DM_ConformedPerson" z

    ON a."Person_SK" = z."Person_SK"

    WHERE z."Person_SK" z."MaxSK"

    Because of this solution, I have now joined this web site to hopefully easily find solutions such as this in the future.