ERP數量異常查詢
電線01庫存數量不符合
<sql> SELECT * FROM( SELECT RTRIM(MF001) MF001,SUM(MF008*MF010*-1) AS Q FROM INVMF WHERE MF010<>0 AND MF002='000' AND MF007='01' GROUP BY MF001)X WHERE Q<>0 /* SELECT X.MF001,X.MF010,SMF010 FROM (SELECT MF001,SUM(MF010*MF008) AS MF010 FROM INVMF JOIN INVMB ON MB001=MF001 WHERE MF001 NOT LIKE '6%' AND MF007='01' AND MF002<>'000' AND MB007='302' GROUP BY MF001)X JOIN (SELECT MF001,SUM(MF010*MF008) AS SMF010 FROM INVMF JOIN INVMB ON MB001=MF001 WHERE MF001 NOT LIKE '6%' AND MF007='01' AND MB007='302' GROUP BY MF001)Y ON X.MF001=Y.MF001 WHERE MF010<>SMF010 //由電線01庫之批號000排除與不排除之進出數量合來判斷
- /
</sql>