新加工工程單

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

<sql> SELECT TA002,MA002,X.*,TA524,TA525,TA526,TA527,TA510 FROM (SELECT TG003,TD001,TG004,TH008,TH009,TD013,TH004,COPTH.UDF03,TD002,TD003 FROM COPTH JOIN COPTG ON TG001=TH001 AND TG002=TH002 JOIN COPTD ON TH014=TD001 AND TH015=TD002 AND TH016=TD003 WHERE TD001='2202' AND TG003 >'20151115' AND TD021='Y' AND TH020<>'V')X LEFT JOIN MOCTA ON TA026=TD001 AND TA027=TD002 AND TA028=TD003 JOIN COPMA ON MA001=TG004 WHERE TA013='Y' </sql>