please help for this requirement is join sum of subtotal.
I have a result table like this. Picture Table
CID | STORECODE | STORENAME | CONTRACTNO | SUBTOTAL
---------------------------------------------------------
222 | SCI-SCG5 | S2 | 111 | 657,534.20
221 | SCI-SCG5 | S2 | 110 | 700,000
how to get result like this:
CID | STORECODE | STORENAME | CONTRACTNO | SUBTOTAL
----------------------------------------------------------
222,221 | SCI-SCG5 | S2 | 111,110 | 1.357.534,20
OR
STORECODE | STORENAME | SUBTOTAL
--------------------------------
SCI-SCG5 | S2 | 1.357.534,20