預計元件用量估算

出自TSK WIKI
於 2015年12月15日 (二) 15:19 由 Root​(留言 | 貢獻) 所做的修訂 (新頁面: ==程式碼== <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 MD...)
(差異) ←上個修訂 | 最新修訂 (差異) | 下個修訂→ (差異)
跳至導覽 跳至搜尋

程式碼

<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>