34,590
社区成员
发帖
与我相关
我的任务
分享
UPDATE TABLE1
SET table1.bm = table2.bm ,
table1.dw = table2.dw
FROM TABLE1
INNER JOIN table2 ON TABLE1.w_name = table2.w_name
;
WITH cte
AS ( SELECT a.w_name ,
a.bm ,
a.dw
FROM table2 a
INNER JOIN TABLE1 b ON a.w_name = b.w_name
)
UPDATE TABLE1
SET table1.bm = cte.bm ,
table1.dw = cte.dw
FROM TABLE1
INNER JOIN cte ON TABLE1.w_name = cte.w_name