「WF+CALC自製程式」:修訂間差異
跳至導覽
跳至搜尋
新頁面: ==未來規畫== *訂單單身匯入程式 |
|||
| 第1行: | 第1行: | ||
==未來規畫== | ==未來規畫== | ||
*訂單單身匯入程式 | *訂單單身匯入程式 | ||
==多訂單合一之品號條碼== | |||
*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:54 的修訂
未來規畫
- 訂單單身匯入程式
多訂單合一之品號條碼
- 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