SQL SUM Problem

here i've joined two tables , now what i need to do is sum the productPrice of the rows with the same customerID .. order id and product id are the primary key

-SELECT * FROM [Sale Order] INNER JOIN Product ON [Sale Order] productID = Product.productID