Stanley預計撰寫的程式

出自TSK WIKI
跳至導覽 跳至搜尋
  • 使用zxing Barcode讀取程式設計線邊倉盤點程式

貼紙程式修改

<sql> SELECT X.UDF03 AS STICKER,TD064,RTRIM(TA002)AS TA002,MA002,TA015,TA010,RTRIM(MB001) AS MB001, TD005,TD006,TD020,MB028,TD001+RTRIM(TD002)+TD003 AS TD123 FROM COPTD JOIN COPTC ON TD001=TC001 AND TD002=TC002 JOIN MOCTA ON TA001='5102' AND TA002=TD054 JOIN COPMA ON TC004=MA001 JOIN INVMB X ON TD004=MB001 WHERE TA013='Y' AND TD021='Y' AND TD016<>'V' </sql>

銅價匯率