SQL SERVER数据库根据其他某个表的字段批量修改数据
2020-07-29 本文已影响0人
天马行空_9f6e
SQL SERVER
UPDATE A
SET A1 = t2.B2 ,
A2 = t2.C1
FROM A INNER JOIN (
SELECT B.B1,B.B2,C.C1
FROM B left join C on B.B3 = C.C3) t2
ON A.A3 = t2.B1
WHERE A.A4 = 1;
UPDATE oaaccounts
SET F_UseType = t2.F_Type
FROM oaaccounts INNER JOIN OaPayOnline t2
ON F_Order_Id = t2.acid
