大家给看看怎么做？我写了几句，不行啊！感觉还差一个循环？不知道怎么做了？
sele a
use 第一表
sele b
use 第二表
do while .eof.
       if a->工号<>b->工号
           SCATTER TO 变量 MEMO
          USE 第一个表
            APPEND BLANK
            GATHER FROM 变量
        endif
         skip
enddo

DO WHILE .EOF. ？

INSERT INTO B表 SELECT * FROM A表 WHILE A表.工号<>B表.工号

试过了，提示语法错

Select * From Table1 Where KeyField Not In (Select KeyField From Table2) Into Cursor Table3
Select Table2
Append From Table3

Select * From Table1 Where KeyField Not In (Select KeyField From Table2) Into Cursor Table3
这条成功，显示table3选出了7条记录，
可Select Table2
Append From Table3
没添加上，table3里没记录。

Select * From Table1 Where KeyField Not In (Select KeyField From Table2) Into Table Table3
Select Table2
Append From Table3

或者

Select * From Table1 Where KeyField Not In (Select KeyField From Table2) Into Array ArrayName
Select Table2
Append From Array ArrayName