数据库查询可以正常运行而网页运行显示ds1配置错误“加工单号”不明确。但数据连接成功且SQL语句可以正常运行，实在搞不懂是哪里出问题了……SELECT DISTINCT mx.加工单号, mx.加工类别, mx.性能, mx.成品规格, a.加工商代码, mx.应出片, bz.检验日期, MAX(bz.检验日期) OVER (PARTITION BY mx.加工单号) AS 最大检验日期, bz.包装合格数量FROM 生产计划明细_加工 mxLEFT JOIN (SELECT 加工商代码,加工单号,工序号 FROM 加工流通单 WHERE 工序号=1 GROUP BY 加工商代码,工序号,加工单号) a ON mx.加工单号 = a.加工单号LEFT JOIN (SELECT 加工单号, 检验日期, SUM(合格数量) AS 包装合格数量 FROM 成品包装 GROUP BY 加工单号, 检验日期) bz ON mx.加工单号 = bz.加工单号 WHERE mx.在线 = '完成' AND bz.包装合格数量 IS NOT NULL ${if(len(加工类别) == 0,"","and 加工类别 in ('" + replace(加工类别,",","','") + "')")} ${if(len(性能) == 0,"","and 性能 in ('" + replace(性能,",","','") + "')")} ${if(len(加工单号) == 0,"","and 加工单号 in ('" + replace(加工单号,",","','") + "')")} ${if(len(成品规格) == 0,"","and 成品规格 in ('" + replace(成品规格,",","','") + "')")} ${if(len(加工商代码) == 0,"","and 加工商代码 in ('" + replace(加工商代码,",","','") + "')")} ORDER BY mx.加工单号, bz.检验日期
