主题：二个表“当年工资库”和“历年工资库”，数据列相同，如何提取后台数据到一个查询表中？

Dim jb1 As New SQLJoinTableBuilder("历年工资明细汇总","历年工资库")

jb1.ConnectionName = "GSGL2017"

Dim Cols1() As String = {"姓名","年度","月份"}

Dim Cols2() As String = {"姓名","年度","月份"}

jb1.AddTable("历年工资库",Cols1,"当年工资库",Cols2)

jb1.AddCols("{历年工资库}. *")

jb1.Distinct = True   '排除重复值

'jb1.Filter = "客户名称 = '红阳事业'"

Vars("sbmxdt") = jb1.Build()

MainTable = Tables("历年工资明细汇总")