主题：from子句怎么错了

Dim dt As DataTable
Dim cmd As New SQLCommand
cmd.CommandText="Select * FROM {T_CW_VoucherMerge} where {T_CW_VoucherMerge}.vchtype=34"
dt=cmd.ExecuteReader()
Dim jb As new SQLJoinTableBuilder("进货明细","dlybuy")
jb.addtable("dlybuy","vchcode","{dt}","vchtype")
jb.AddCols("{dlybuy}.vchcode","atypeid","ptypeid","qty","costprice","costtotal","period","{dlybuy}.vchtype","redword")
jb.Build()
MainTable=Tables("进货明细")

ExecuteReader生成的临时表，不能作为SQLJoinTableBuilder的来源表，SQLJoinTableBuilder的来源表必须是后台数据库中实际存在的表。

那我从 表2中查询的结果值  与  表1  具有一对多的关系，怎么组合生成一个多表的查询

 

SQLJoinTableBuilder也可以设置条件。

是象 这里的jb.filter="产品名称 = '浓缩咖啡'"吗

Dim jb As New SQLJoinTableBuilder("查询表1","订单")
jb.ConnectionName = "Sale"
jb.AddTable("订单","产品ID","产品","产品ID")
jb.AddTable("订单", "客户ID","客户","客户ID")
jb.AddCols("客户名称")
jb.Filter = "产品名称 = '浓缩咖啡'"
jb.Distinct = True
jb.Build()
MainTable = Tables("查询表1")

 

 

是的