How do I combine two rows of same part, but add quantities?
- by Tom
I have table "PICKITEM"
PARTID QTY
A 1
A 3
B 11
C 8
D 5
D 3
I need a select statement that will return one line for like PARTIDs and add the qty field to together, yet also return the rest of the lines in the table as is
PARTID QTY
A 4
B 11
C 8
D 8
Probably a newb question, but I am new to SQL syntax and queries. Any help in getting me on the right path would be appreciated!