程序代码：

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）