台康來料追蹤
程式碼
<sql> SELECT TA001,TA002,TA006,TA034,TA035,TA013,TA510,TA520,TA522,TA524,TA526,TA011 FROM (SELECT MD001 FROM (SELECT TB001,TB002,TB003,TB004,TB005,TB006,TB007,TB018,MD001 FROM INVTB JOIN BOMMD ON MD003=TB004 WHERE TB001='1105' AND TB004 LIKE '60518%' AND TB018='Y') X GROUP BY MD001)Y JOIN MOCTA ON TA006=MD001 JOIN MOCTE ON TA001=TE011 AND TA002=TE012 WHERE TE019='Y' AND TA013<>'V' AND TA011<>'Y' AND TA011<>'y'
</sql>