Product of two table feilds

If I understood your question well, you need sum of all products?

Then the query is this:
SELECT SUM(Value) AS Total FROM (SELECT productQty * productRate AS Value FROM Product);

Zoran