1、使用以下sql创建查询表:http://www.foxtable.com/webhelp/scr/2321.htm
Select {表A}.* From {表A},{表B} Where {表A}.第二列={表B}.第三列 and {表A}.第四列<>{表B}.第五列
如果导出合并的方式导数据
1、通过代码获取:
Dim dt As DataTable
Dim cmd As New SQLCommand
cmd.CommandText = "Select {表A}.* From {表A},{表B} Where {表A}.第二列={表B}.第三列 and {表A}.第四列<>{表B}.第五列"
dt = cmd.ExecuteReader()
Dim f As New Filler
f.SourceTable = dt
f.DataTable = DataTables("表C") '指定数据接收表
f.Fill() '填充数据