summation of record values

[jenodorf]

Hi

have a mysql database running on the web. One table has stock quantity and stock cost. I need to show the total value of the stock held on a web administration page.

From the books/manuals and the web I think the fomat should be

SELECT Sum (Price * Stock)

But how do I specify the table?



thanks

Ian

 

[jpadie]

Select sum (price * stock) as totalStockValue from tablename