Update a set a.f_dxbh1=b.dxlb1,a.f_dxbh2=b.dxlb2,a.f_dxbh3=b.dxlb3,a.f_kmbh=b.kmbh,a.f_kmlb=b.bbh,a.f_lbmc=b.lbmc from #FEfl0001 a,lskmlb b where a.id=b.id
Update #FEfl0001 set f_dxbh1=a.dxlb1,f_dxlb2=a.dxlb2
,f_dxlb3=a.dxlb3,f_kmbh=a.kmbh
,f_bbh=a.bbh,f_lbmc =a.lbmc
from lskmlb a ,#FEfl0001 b where a.关键字=b.关键字