MULTIPLYING BY A STOCK NUMBER 1

[ptweb]

Hi

I have this query to give me a totalprice...

SELECT Sum(products.Price) AS SumOfPrice
FROM products;


...how can one alter this so the SumOfPrice is the products.Price multiplied by the stock amount on a different column?? the stock column is called stock... ;-)

Many Thxs Gary

 

[JamesLean]

SELECT SUM(price * stock) AS sumofprice
FROM products

--James

 

[ptweb]

Give the man a ceeeeeeeeegar.!!