意会代码:
SELECT A表1列,A表2列,RECNO() ID FROM A表 INTO CURSOR T1
SELECT B表1列,B表2列,RECNO() ID FROM B表 INTO CURSOR T2
SELECT A.ID,A表1列,A表2列,B表1列,B表2列 FROM t1 A LEFT JOIN t2 B ON A.ID=B.ID INTO dbf 新表
INSERT INTO 新表 (B表1列,B表2列) SELECT a.B表1列,a.B表2列 FROM t2 a left join 新表 b on a.id=b.id WHERE b.id is null