Trying to figure out the sum of a certain variable not total sum using sql -


I am having a temperament here but my question is fast

I have a table like the following Is:

  the cut part quantity rtn volume which is A1 2 0 which is A2 3 1 which is A1 2 2 bob A1 3 4 bob A2 4 0   

I want the result to be such as:

  which is A1402 which is A2 3 1bob A132bob A240 0   < P> I am trying to explain how to make an amount according to the different part of each customer?  

It looks like a straightforward group at crust, part Choose Cost, Part, Zodiac (Amount), Zodiac ([Rtn Quantity]) from yourtelable group by :

  Cast, Part    

Comments