3001 10 3002 5 3001 6 3002 4I append them to the table:
use myorder append from "order.txt" sdfthen I get:
StockId Qty ------- ---- 3001 10 3002 5 3001 6 3002 4while I wish the same StockId will be total together:
StockId Qty
------- ----
3001 16
3002 9
is there any easy way to do it?