LINE BOT WM
跳至導覽
跳至搜尋
<SQL> SELECT COPTD.CREATE_DATE+' '+COPTD.CREATE_TIME CR ,TD041,TD005,TD006,CAST(TD008 AS INT) TD008,CAST(SMC007 AS INT) SMC007, Convert(varchar,Convert(Datetime,TD013,112),111) TD013,COPTD.UDF05 UDF05,MV002 FROM COPTD JOIN v_INVMC01 ON MC001=TD004 JOIN COPTC ON TC001=TD001 AND TC002=TD002 JOIN CMSMV ON MV001=TC006 WHERE TD002>'190319000' AND RTRIM(COPTD.UDF05)= AND TD001= 2201 </SQL>