Trying for multiplication in query

Hi,

I think someone may tell me to do this post-process but here goes.

querying a table for several records and two cols from each - quantity and price.

eg


| id | quantity | price | 
| 2  | 34       | 11.68 |
| 3  | 3        | 5.48  | 

I would like the returned result to the multiplication of quantity and price, totalled over all records.

ie

34 * 11.68

  • 3 * 5.48

result returned 413.56

do-able??

bazz

try SELECT SUM(quantity*price)

Thanks ScallioXTX.

That does what I need perfectly.

bazz