菜鸟小新一枚:
UPDATE a
SET a.addr=a.addr+'-'+b.doorplate
FROM takedata..workorder2019 a
LEFT JOIN BaseData.dbo.Meterdoor b on a.regist_no=b.regist_no
where WorkOrderType_Name='**' and book in (**)
update a
SET a.mk_no =t1.mk_no ,a.electron_no=t1.electron_no
FROM basedata2020..meterdoor a
left join basedata2019..meterdoor t1 on a.regist_no =t1.regist_no
where a.regist_no in (**)