SELECT a.id, a.S_CUSTOMER, a.s_order, a.s_isbn, a.s_batchnum, a.s_free1, a.s_goodsname, a.S_PRODUCTSIZE, a.I_QTY, a.I_ManualPrice, a.I_ManualAmount, a.D_DELIVERYDATE, A.D_CREATED, a.S_employee, a.S_QUOTATIONNO /* b.id, b.S_QUOTATIONNO, b.S_ITEMMASTER, b.S_GOODSNAME, c.s_spdname, c.S_ITEMMASTER, c.I_QUOTE, d.I_QUOTATIONNO */ from T_TR_MARKETFORM a /*-- inner join T_QU_MARKETFORM b on b.S_QUOTATIONNO=a.S_QUOTATIONNO left join T_PRE_BOMPDLIST c on c.s_spdname=b.S_GOODSNAME and c.S_ITEMMASTER=b.S_ITEMMASTER left join T_PD_PRODUCTION d on d.I_QUOTATIONNO=c.I_QUOTE or d.I_QUOTATIONNO=b.ID --*/ where ${where} order by a.ID asc 注释掉关联表就不报错了,但是为什么FR预览没问题,WEB输出报表就报错?请指教! |