預交日工程單
程式碼
<sql> SELECT TD013,MA002,TA002,TD005,TD006,TD008,TD010,TA010,TD001,TA520,TA521,TA522,TA523,TA524,TA525,TA526,TA527, (SELECT CASE WHEN TA526<> AND TA527<> THEN 'OK' WHEN TA520<> AND TA521= THEN '在裁線' WHEN TA522<> AND TA523= THEN '在焊接' WHEN TA524<> AND TA525= THEN '在端子' WHEN TA526<> AND TA527= THEN '在組裝' WHEN TA520= AND TA522= AND TA524= AND TA526= THEN '排單中' END) AS TA527,(SELECT CASE WHEN TC012<> THEN TC012 ELSE X.UDF02 END)AS TC012 FROM v_COPTCD X JOIN v_MOCTANOTV ON TD001=(SELECT CASE WHEN TA033<> THEN '400' ELSE TA026 END) AND TD002=(SELECT CASE WHEN TA033<> THEN REPLACE(TA033,'*',) ELSE TA027 END) AND TD003=(SELECT CASE WHEN TA033<> AND TA028= THEN TD003 ELSE TA028 END) JOIN COPMA ON MA001=TC004 WHERE TA010='20151207' </sql>