I have table called "Cart". Fields are :

* `CartId`
* `ClientId`
* `ProductId`
* `Qty`

Now i am joining this table with `ProductMaster` to get `ProductName` and `ProuctPrice`

```
select cc.CartId,cc.ProductId,pm.ProductName,cc.Qty,
        (pm.ProductPrice * cc.Qty) As SubTotal 
from ClientCart as cc 
    inner join ProductMaster as pm on cc.ProductId = pm.ProductId 

```

Now I want to genrate `GrandTotal` using dynamic field `SubTotal`. How Can i do this?