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

沒文件驗證,不知對不:

Dim jb As new SQLJoinTableBuilder("查询表1","订单明细")

jb.Connection Name = "Sale"

jb.AddTable("订单明细","产品ID","产品","产品ID")

jb.AddTable("订单明细","订单ID","订单","订单ID")

jb.AddTable("订单","客户ID","客户","客户ID")

jb.AddExp("产品","产品名称")

jb.AddCols("订购日期","公司名称","产品名称", "数量","{订单明细}.单价", "折扣")

jb.AddExp("金额", "数量 *{订单明细}.单价 * (1-折扣)")

jb.Build()

MainTable = Tables("统计表1")

[此贴子已经被作者于2012-3-16 16:24:36编辑过]

主题：sql转换SQLJoinTableBuilder