SQLJoinTableBuilder可以用不同的数据源吗 - 专家坐堂 - Foxtable(狐表) - 新一代数据库软件，完美融合Access、Foxpro、Excel、vb.net之优势，人人都能掌握的快速软件开发工具!

参考：http://www.foxtable.com/webhelp/scr/2320.htm

先生成查询表，然后再统计

2个数据源的表名都是pos_t_saleflow?

既然不是你的代码就要区分啊

Dim jb2 As New SQLJoinTableBuilder("查询表1","表1")

jb2.C

jb2.AddTable("pos_t_saleflow","flow_no","flow_remind_time","flow_no")

jb2.AddCols("flow_no","vip_no","remind_time","flow_remind_time","vip_adviser","remark")

Dim jb3 As New SQLJoinTableBuilder("查询表1","表2")

jb3.C

jb3.AddTable("pos_t_saleflow","item_no","bi_t_item_info","item_no")

jb3.AddCols("item_name")

jb2.Merge(jb3) '组合jb3

jb2.Build()

Dim t As Table = e.Form.Controls("Table1").Table

t.DataSource = jb2

生成的查询表是要分别从三个不同的表生成的，然后再组合这三个生成的查询表啊。仔细看2楼帮助的代码

表名和数据源匹配就可以了

Dim jb1 As New SQLJoinTableBuilder("查询表1","表1")
jb1.ConnectionName = "Sale1"
jb1.AddTable("订单","产品ID","产品","产品ID")
jb1.AddTable("订单", "客户ID","客户","客户ID")
jb1.AddCols("产品名称","客户名称","日期", "数量","单价")
jb1.AddExp("金额","数量 * 单价")
jb1.Filter = "客户名称 = '红阳事业'"

Dim jb2 As New SQLJoinTableBuilder("查询表1","表2")
jb2.ConnectionName = "Sale1"
jb2.AddTable("订单","产品ID","产品","产品ID")
jb2.AddTable("订单", "客户ID","客户","客户ID")
jb2.AddCols("产品名称","客户名称","日期", "数量","单价")
jb2.AddExp("金额","数量 * 单价")
jb2.Filter = "客户名称 = '红阳事业'"

Dim jb3 As New SQLJoinTableBuilder("查询表1","表3")
jb3.ConnectionName = "Sale2"
jb3.AddTable("订单","产品ID","产品","产品ID")
jb3.AddTable("订单", "客户ID","客户","客户ID")
jb3.AddCols("产品名称","客户名称","日期", "数量","单价")
jb3.AddExp("金额","数量 * 单价")
jb3.Filter = "客户名称 = '红阳事业'"

jb1.Merge(jb2) '组合jb2
jb1.Merge(jb3) '组合jb3
jb1.Build()

主题：SQLJoinTableBuilder可以用不同的数据源吗