計算OKUMA元件用量

出自TSK WIKI
於 2015年12月11日 (五) 22:07 由 Root​(留言 | 貢獻) 所做的修訂 (新頁面: ==程式碼== <sql> SELECT MD003,(NUM*MD006/MD007*-1)AS AMOUNT FROM INVMB JOIN (SELECT NAME,SUM(NUM) AS NUM FROM OKUMA WHERE PRDATE BETWEEN '20160101' AND '20160301' GROUP BY NAME)X ON...)
(差異) ←上個修訂 | 最新修訂 (差異) | 下個修訂→ (差異)
跳至導覽 跳至搜尋

程式碼

<sql> SELECT MD003,(NUM*MD006/MD007*-1)AS AMOUNT FROM INVMB JOIN (SELECT NAME,SUM(NUM) AS NUM FROM OKUMA WHERE PRDATE BETWEEN '20160101' AND '20160301' GROUP BY NAME)X ON MB002=NAME JOIN BOMMD ON MB001=MD001 WHERE NUM >'0' AND MB031 <'0' AND MD017<>'4' </sql>