inse into 子表 sele * from 总表 where !( sfzh in(sele sfzh from 子表) ) use in 总表 sele * from 子表 orde by sfzh into tabl 总表
sele * from 总表 where !( sfzh in(sele sfzh from 子表) ) into tabl tmp sele 总表 zap appe from tmp appe from 子表