Have you tried something like this?
UPDATE Table_1 a SET a.Column = 1 WHERE a.PK IN (SELECT b.PK FROM Table_1 b WHERE "conditon = criteria")
Have you tried something like this?
UPDATE Table_1 a SET a.Column = 1 WHERE a.PK IN (SELECT b.PK FROM Table_1 b WHERE "conditon = criteria")