Hello!! i need some help in building a sql server select statement: i have a table with these columns and info: product_id | quantity ------------------------ prod1 | 2 prod1 | 4 prod2 | 4 prod3 | 3 prod2 | 2 prod2 | 1 i need to build a statement in order to have each product and how many items of the product i have in existence (sum of quantities of each occurrence of a product). so the query result would look like this: product_id | quantity ------------------------ prod1 | 6 prod2 | 7 prod3 | 3 any help will be appreciated. thnx!!

I don't speak SQL Server, but this is the general select command you are looking for: select product_id, sum(quantity) from product_table group by product_id order by product_id