主题：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("进货明细")

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

 

是象 这里的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")