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

CVD vs HPHT: The Differences in Diamond Manufacturing
Best Time to Sell Bitcoin: Key Insights for Crypto Investors
Best Time to Buy Bitcoin: Key Insights for Investors
Diamond Studs: The Ethical and Affordable Choice for Timeless Elegance
Lab Grown Diamond Jewellery: The Sparkle That Doesn’t Break the Bank
Exercise Selection Guide: How to Choose the Right Movements for Maximum Results