程式碼
<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>