cnn.dbf
        姓名       工资
        张三       1000
        李四       1500
cnn1.dbf
        姓名       保险
        张三       200
        李四       250
把以上2个表合并名为nn.dbf的表
nn.dbf
        姓名       工资      保险
        张三       1000      200
        李四       1500      250

select T1.*,T2.保险 from cnn T1,cnn1 T2 where ALLTRIM(T1.姓名)=ALLTRIM(T2.姓名) into table nn


[ 本帖最后由 taifu945 于 2014-3-4 15:46 编辑 ]

sele cnn.*,cnn1.保险 from cnn left join cnn1 on cnn.姓名=cnn1.姓名 into dbf cn

select a.*,b.保险 FROM CNN A INNER JOIN CNN1 B ON ALLTRIM(A.姓名)=ALLTRIM(B.姓名) into table nn