Dim jb As New SQLJoinTableBuilder("物品资料","单据_库存")
jb.C
jb.AddTable("单据_库存","产品编号","基础_产品","产品编号")
jb.AddTable("基础_产品","产品编号","基础_产品_单位信息","产品编号")
jb.AddExp("编码及名称_编码","编码")
jb.AddExp("编码及名称_名称","名称")
jb.AddExp("编码及名称_型号","规格型号")
jb.AddCols("单位名称")
jb.AddExp("库存详情_账面库存","SUM(账面数量)")
jb.Build()
Tables("产品资料_Table1").DataSource = jb.BuildDataSource
“
选择列表中的列 '基础_产品.编码' 无效,因为该列没有包含在聚合函数或 GROUP BY 子句中。”
我知道sql语句,GROUP BY后面要加上非聚合函数列名,有啥方法不用写sql语句实现吗?