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

Dim sg As New SQLJoinTableBuilder("订单查询","采购订单主表")

sg.AddTable("采购订单主表","订单编号","采购订单","订单编号")

sg.AddCols("{采购订单主表}.订单编号","{采购订单主表}.供应商","{采购订单主表}.日期","审核","审批","{采购订单主表}.部门","品牌","型号","数量","含税单价","{采购订单主表}.金额")

sg.Filter = "供应商='XXX' and 部门='XXX'"

sg.Build()

主题：联合查询