if I have the following cursor and I want a total of each amount belonging to an item how would I go about writing an sql statement for that.
x y
2 bells
5 tables
3 bells
4 glasses
I need the result to show up as:
x y
5 bells
4 glasses
5 tables
Thanks
Nick Patel