Tables("数据调用测试窗口_table1").Fill("Se lect a.物料编码 From {物料清单} a INNER JOIN (S elect {物料表}.*,{工库方案}.*,{订单明细表}.*,{工序库明细主表}.*,{工序库明细}.*,{工序表}.* From (((({物料表} Inner JOIN {工库方案} ON {工库方案}.[物料编码] = {物料表}.[物料编码]) Inner JOIN {订单明细表} ON {订单明细表}.[产品编码] = {工库方案}.[物料编码]) Inner JOIN {工序库明细主表} ON {工序库明细主表}.[物料编码] = {订单明细表}.[产品编码]) Inner JOIN {工序库明细} ON {工序库明细}.[编码] = {工序库明细主表}.[编码]) Inner JOIN {工序表} ON {工序表}.[工序编号] = {工序库明细}.[工序编码] where {订单明细表}.[内部加工单号] = '17p-测试' and ({工库方案}.配色号 ={工序库明细}.配色 or {工序库明细}.配色 = 0)) b on a.物料编码 = b.物料编码" ,"a",True)
版主请教以上代码,提示se lcet 语句执行错误请检查语法及数据源错误
单独执行下面语句没有错误
S elect {物料表}.*,{工库方案}.*,{订单明细表}.*,{工序库明细主表}.*,{工序库明细}.*,{工序表}.* From (((({物料表} Inner JOIN {工库方案} ON {工库方案}.[物料编码] = {物料表}.[物料编码]) Inner JOIN {订单明细表} ON {订单明细表}.[产品编码] = {工库方案}.[物料编码]) Inner JOIN {工序库明细主表} ON {工序库明细主表}.[物料编码] = {订单明细表}.[产品编码]) Inner JOIN {工序库明细} ON {工序库明细}.[编码] = {工序库明细主表}.[编码]) Inner JOIN {工序表} ON {工序表}.[工序编号] = {工序库明细}.[工序编码] where {订单明细表}.[内部加工单号] = '17p-测试' and ({工库方案}.配色号 ={工序库明细}.配色 or {工序库明细}.配色 = 0)
[此贴子已经被作者于2017/3/2 11:00:38编辑过]