「WF+CALC自製程式」:修訂間差異
跳至導覽
跳至搜尋
| (未顯示同一使用者於中間所作的 1 次修訂) | |||
| 第2行: | 第2行: | ||
*訂單單身匯入程式 | *訂單單身匯入程式 | ||
==多訂單合一之品號條碼== | ==多訂單合一之品號條碼== | ||
*SELECT '*'+ | *SELECT '*'+TD004+'*'AS MB001,MB002,MB003,AMOUNT FROM INVMB JOIN (SELECT SUM(TD008) AS AMOUNT,TD004 FROM COPTD WHERE TD001='2202' AND TD002 ='150303014' GROUP BY TD004) X ON MB001=X.TD004 | ||
於 2015年3月11日 (三) 15:40 的最新修訂
未來規畫
- 訂單單身匯入程式
多訂單合一之品號條碼
- SELECT '*'+TD004+'*'AS MB001,MB002,MB003,AMOUNT FROM INVMB JOIN (SELECT SUM(TD008) AS AMOUNT,TD004 FROM COPTD WHERE TD001='2202' AND TD002 ='150303014' GROUP BY TD004) X ON MB001=X.TD004