复制数据
insert into ATB_AppCusInfo (clientSN)
select a.danwbh from ksoa.dbo.mchk a left join rebate.dbo.ATB_AppCusInfo b on a.dwmch=b.clientName where b.drugName='复方血栓通胶囊'
update ATB_billInfo set easyCode=a.zjm from ksoa.dbo.spkfk a inner join rebate.dbo.ATB_billInfo b on a.spbh=b.drugSN