sqlserver 联查修改

UPDATE A
SET A.delete = 1  -- 或者您想要设置的值
FROM TableA A
INNER JOIN TableB B ON A.关联字段 = B.关联字段
WHERE B.code = 111;