程序代码:
SET engi 70 CLOSE DATABASES SELECT 号码3 as fielm from 表2 into table tmp SELECT 号码1 as fielm from 表1 into table tmp1 SELECT 号码2 as fielm from 表1 into table tmp2 && 这三句转换成相同字段名的三个表 SELECT tmp APPEND FROM tmp1 APPEND FROM tmp2 &&& 这三句 是把三表合一 SELECT * from tmp where !EMPTY(fielm) grou by fielm into dbf jg &&& 去掉空的和重复的。得到 结果(JG.DBF)