預計元件用量估算
程式碼
<SQL> SELECT TD004,MB002,MB003,AMOUNT*-1 AS AMOUNT,SMC007,SMC007+AMOUNT AS DIFF FROM(SELECT TD004,SUM(TD008) AS AMOUNT FROM (SELECT A.* FROM v_PREINOUT A JOIN (SELECT MD003 FROM INVMB JOIN cars ON MB002=A01 JOIN BOMMD ON MD001=MB001 WHERE (MB031<'20151215' OR MB031=) AND MD017<>'4' GROUP BY MD003
)X
ON TD004=MD003 WHERE TD003 BETWEEN '20151215' AND '20160215' UNION ALL SELECT '0000' AS TD001,'1234' AS TD002,'0000' AS TD003, MD003,(MD006/MD007*A02)*-1 AS AMOUNT, 'N' AS TD016,'20151215' AS TD013 FROM INVMB JOIN cars ON MB002=A01 JOIN BOMMD ON MD001=MB001 WHERE (MB031<'20151215' OR MB031=) AND MD017<>'4')Y GROUP BY TD004)Z JOIN v_INVMC ON TD004=MC001 JOIN INVMB ON MB001=TD004 </SQL>