主题：多表查询后怎么统计（没解决,新手请帮忙）？

Dim sql As String

Dim dst1 As Table = Tables("窗口1_Table1")

Dim jb As New SQLJoinTableBuilder("查询表1","库存")

jb.AddTable("库存","货品编码","库存商品","货品编码")

jb.AddCols("{库存}.货品编码","当前库存","货品类型","计量单位","货品名称","规格型号")

jb.AddCols("生产厂商","库存上限","库存下限","入库参考价","出库参考价","备注")

sql = jb.BuildSQL.Replace("Select","Select DISTINCT")

dst1.fill(sql,True)