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
Best Crystallizer Manufacturer for Industrial Crystallization, Filtration & Drying Equipment
What Is a Bead Mill? Complete Guide to Sand Mills and Wet Grinding Technology
A Guide To Lighting Both Inside and Outside the Home
Home Gas Line Installation: What To Expect From the Service
Signs Your Water Heater Needs Repair
CVD vs HPHT: The Differences in Diamond Manufacturing
Best Acupuncture TCM in Singapore: A Guide to Holistic Healing and Wellnes
revita-clinic.eu Review: Modern Healthcare for Better Living