[求助] - 专家坐堂 - Foxtable(狐表) - 新一代数据库软件，完美融合Access、Foxpro、Excel、vb.net之优势，人人都能掌握的快速软件开发工具!

Dim jb As New SQLJoinTableBuilder("查询表1","材料表")

jb.AddTable("材料表","清单编号","产品表","清单编号")

jb.AddTable("产品表", "物料编码","物料编码设置","物料编码")

jb.AddTable("物料编码设置","单位编码","单位设置", "单位编码")

jb.AddCols("{产品表}.清单编号","{产品表}.物料编码 AS 产品编码","物料名称", "规格型号","单位名称 AS 产品单位","{材料表}.物料编码 As 材料编码","单机用量")

jb.filter = "{物料表}.物料名称 = '123456' and {单位}.单位名称 = 'abc' "

jb.Build()

主题：[求助]