「WF+CALC自製程式」:修訂間差異

出自TSK WIKI
跳至導覽 跳至搜尋
Root​(留言 | 貢獻)
Root​(留言 | 貢獻)
第2行: 第2行:
*訂單單身匯入程式
*訂單單身匯入程式
==多訂單合一之品號條碼==
==多訂單合一之品號條碼==
*SELECT X.TD004,MB002,X.AMOUNT FROM INVMB JOIN (SELECT COUNT(*) AS AMOUNT,TD004 FROM COPTD WHERE TD001='2202' AND TD002 ='150303014' GROUP BY TD004) X ON MB001=X.TD004
*SELECT '*'+X.TD004+'*',MB002,X.AMOUNT FROM INVMB JOIN (SELECT COUNT(*) AS AMOUNT,TD004 FROM COPTD WHERE TD001='2202' AND TD002 ='150303014' GROUP BY TD004) X ON MB001=X.TD004

於 2015年3月10日 (二) 12:56 的修訂

未來規畫

  • 訂單單身匯入程式

多訂單合一之品號條碼

  • SELECT '*'+X.TD004+'*',MB002,X.AMOUNT FROM INVMB JOIN (SELECT COUNT(*) AS AMOUNT,TD004 FROM COPTD WHERE TD001='2202' AND TD002 ='150303014' GROUP BY TD004) X ON MB001=X.TD004