司機出貨容積估算

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

<SQL> SELECT TA002,MA002,X.*,TA524,TA525,TA526,TA527,TA510,MOCTA.UDF06 AS PST2,ISNULL(ID,'NONE') ID, ISNULL(BOXREMARK,'NONE') BOXREMARK,ISNULL(V,0) V, (SELECT CASE WHEN X.UDF06 >'0' THEN ELSE '+' END) AS PST FROM (SELECT TG003,TD001,TG004,TH008,TH009,TD013,TH004,TH005,TH006,TH019,COPTH.UDF03,TD002,TD003,TG002,TH003,COPTH.UDF06 FROM COPTH JOIN COPTG ON TG001=TH001 AND TG002=TH002 JOIN COPTD ON TH014=TD001 AND TH015=TD002 AND TH016=TD003 WHERE TG003 >'20151115' AND TD021='Y' AND TH020='N')X LEFT JOIN MOCTA ON TA026=TD001 AND TA027=TD002 AND TA028=TD003 LEFT JOIN v_BOXSIZE ON CONTENT=TA002 JOIN COPMA ON MA001=TG004 JOIN INVMB ON MB001=TH004 WHERE TA013='Y' AND (MB007='301' OR TD001='2202') AND TG003='20200214' ORDER BY X.UDF06,MA002,X.UDF03,TA002 </SQL>