mysql做法:
UPDATE table A
LEFT JOIN
table B
ON
A.B_ID = B.B_ID
SET
A.A_NAME = B.B_NAME;
SQLServer做法:
update A
set A_NAME = B.B_NAME
from table A left join table B
ON
A.B_ID = B.B_ID
mysql做法:
UPDATE table A
LEFT JOIN
table B
ON
A.B_ID = B.B_ID
SET
A.A_NAME = B.B_NAME;
SQLServer做法:
update A
set A_NAME = B.B_NAME
from table A left join table B
ON
A.B_ID = B.B_ID