Forum Replies Created

Viewing post 16 (of 16 total)

  • RE: DELETE using INNER JOIN

    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" ...

Viewing post 16 (of 16 total)