复制数据

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