Try this on for size:

Code:
SELECT sum(quantity*price) as Total
FROM Table1