I have written below query to get the total of each indicual items with same RequestID(requestitemsID are different)
(ts_a.CostLocal * ts_a.Qty)*(ts_b.ExchangeRate)) as Total_Dollor from ts_a ,ts_b
RequestID RequestItemID CostLocal Qty Total_doller
331 1036 123.0000 2 5.05776
331 1037 100.0000 3 6.168
Now i want get the Total of all requestitems those who having same RequestID.
Can anyone help to write query for the situation?