誤用客供料

出自TSK WIKI
於 2017年3月8日 (三) 15:02 由 Root​(留言 | 貢獻) 所做的修訂 (新頁面: ==OKUMA誤用客供料製令== <SQL> SELECT X.*,MA016,MA002 FROM (SELECT TA001,TA002,TA006,TA034,TA035,TB003 ,TC004,TB004 AS 應領用,TB005 AS 已領用,TA011 AS 製令狀態 FROM MOC...)
(差異) ←上個修訂 | 最新修訂 (差異) | 下個修訂→ (差異)
跳至導覽 跳至搜尋

OKUMA誤用客供料製令

<SQL> SELECT X.*,MA016,MA002 FROM (SELECT TA001,TA002,TA006,TA034,TA035,TB003 ,TC004,TB004 AS 應領用,TB005 AS 已領用,TA011 AS 製令狀態 FROM MOCTB JOIN MOCTA ON TA001=TB001 AND TA002=TB002 JOIN v_COPTCD ON TA001='5102' AND TA002=TD054 WHERE TB018='Y' AND TA011<>'y' AND TD021='Y' )X JOIN COPMA ON MA001=TC004 WHERE TC004='197B' AND TB003 LIKE '601970%' </SQL>