SQLServer的update left join关联更新语法
SQLServer的update left join用法示例:
update A
set A_NAME = B.B_NAME
from A left join B
ON
A.B_ID = B.B_ID
SQLServer的update left join用法示例:
update A
set A_NAME = B.B_NAME
from A left join B
ON
A.B_ID = B.B_ID