超图不动产登记中业务号ＹＷＨ的更新方式

select xmxx.ywlsh,ql.ywh from bdcs_xmxx xmxx inner join bdcs_ql_ls ql on xmxx.xmbh=ql.xmbh;
update bdcs_ql_ls ql set ql.ywh =(select xmxx.ywlsh from bdcs_xmxx xmxx where xmxx.xmbh=ql.xmbh) where ql.xmbh is not null;