Dim jb As New SQLJoinTableBuilder("查询表1","核定编制")
jb.AddCols("单位","编制_XXX编制","编制_参公编制","编制_事业编制" , "编制_工勤编制")
Dim d As fxDataSource = jb.BuildDataSource()
jb = New SQLJoinTableBuilder("查询表1","核定并行")
jb.AddCols("单位","核定职数_领导正职","核定职数_领导副职","核定职级_一级调研员","核定职级_二级调研员","核定职级_三级调研员","核定职级_四级调研员","核定职级_一级主任科员","核定职级_二级主任科员","核定职级_三级主任科员","核定职级_四级主任科员","核定职级_一级科员","核定职级_二级科员")
Dim d1 As fxDataSource = jb.BuildDataSource()
jb = New SQLJoinTableBuilder("查询表1","实有并行")
jb.AddCols("单位","实配职数_领导正职","实配职数_领导副职","实有职级_一级调研员","实有职级_二级调研员","实有职级_三级调研员","实有职级_四级调研员" ,"实有职级_一级主任科员","实有职级_二级主任科员","实有职级_三级主任科员","实有职级_四级主任科员","实有职级_一级科员","实有职级_二级科员")
Dim d2 As fxDataSource = jb.BuildDataSource()
d.Combine("单位",d1,"单位")
d.Combine("单位",d2,"单位")
d.Show("查询表1")
Tables("查询表1").Visible = False
DataTables("汇总表").DataRows.Clear
Dim f As New Filler
f.SourceTable = DataTables("查询表1") '指定数据来源
f.DataTable = DataTables("汇总表") '指定数据接收表
f.Fill() '填充数据
Tables("汇总表").AutoSizeCols
MainTable = Tables("汇总表")