觉得自己写了个棒棒的update

菜鸟小新一枚：

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 (**)