use t2
go top
scan
nbyzh=byzh
scatter to narray1
use t1
if byzh=nbyzh
update t1 SET lm=t2.Lm,ym=t2.Ym,xxlx=t2.Xxlx,byzy=t2.Byzy,cc=t2.Cc,zkyx=t2.Zkyx,zkzh=t2.Zkzh,xm=t2.Xm,xb=t2.Xb,byzh=t2.Byzh,busj=t2.Bysj
else
appe from narray1
endif
endscan
use t2
go top
scan
nbyzh=byzh
scatter to narray1
use t1
if byzh=nbyzh
update t1 SET lm=t2.Lm,ym=t2.Ym,xxlx=t2.Xxlx,byzy=t2.Byzy,cc=t2.Cc,zkyx=t2.Zkyx,zkzh=t2.Zkzh,xm=t2.Xm,xb=t2.Xb,byzh=t2.Byzh,busj=t2.Bysj
else
appe from narray1
endif
endscan
SELECT 1
USE e:\db\t1
SELECT 2
use e:\db\t2
SCAN
t1.byzh=t2.byzh
SELECT 1
LOCA FOR t1.byzh=t2.byzh
IF EOF()
INSERT INTO t1 VALUES(t1.Lm,t1.Ym,t1.Xxlx,t1.Byzy,t1.Cc,t1.Zkyx,t1.Zkzh,t1.Xm,t1.Xb,t1.Byzh,t1.Bysj)
ELSE
UPDATE t1 SET lm=t2.Lm,ym=t2.Ym,xxlx=t2.Xxlx,byzy=t2.Byzy,cc=t2.Cc,zkyx=t2.Zkyx,zkzh=t2.Zkzh,xm=t2.Xm,xb=t2.Xb,byzh=t2.Byzh,busj=t2.Bysj WHERE t1.byzh=t2.byzh
ENDIF
ENDSCAN