主题：SQLLoad不起作用

Dim sql As String

sql = "Select  客户名称,商品编码,商品名称,商品规格,单位,出库单价,数量,日期,审核,{出库单}.结清,出库单编号,商品条形码,商品简称,成本小计,{出库明细}.备注 As [出库单明细备注],{出库单}.备注 As [出库单备注],出库单价*数量 As [小计] From {出库明细} Inner JOIN {出库单} ON {出库单}.[_Identify] = {出库明细}.[出库单编号] Select  客户名称,商品编码,商品名称,商品规格,单位,出库单价,数量,日期,审核,{出库单}.结清,出库单编号,商品条形码,商品简称,成本小计,{出库明细}.备注 As [出库单明细备注],{出库单}.备注 As [出库单备注],出库单价*数量 As [小计] From {出库明细} Inner JOIN {出库单} ON {出库单}.[_Identify] = {出库明细}.[出库单编号]"

sql = sql & " Where {出库明细}.[商品名称] = 'test4'"

DataTables("出库单明细统计").SQLLoad(sql)

---------------------------------------------------

点击按钮执行后，显示所有行，而不是{出库明细}.[商品名称] = 'test4'的行

谢谢LSY