製令缺料查詢

出自TSK WIKI
跳至導覽 跳至搜尋

未確認製令

<SQL> SELECT TB001,TB002,TB003,TB012,TB013,TB004,TB011,SMC007,TA010 FROM MOCTB JOIN MOCTA ON TA001=TB001 AND TA002=TB002 JOIN v_INVMC ON MC001=TB003 WHERE TA001='5102' AND TA013='N' AND TB011<>'4' AND (SMC007-TB004) < 0 </SQL>