[firebird-support] Need some direction on combining values into one

[jim.rhema316]

Good afternoon!

I have a table (see below) where I want to combine the two totals below into 
the 0304KZ6 total so that I can end up with something like the second example.

current 0304KZ6         6786.11
        0304KZ6RR       3750.41

desired 0304KZ6         10536.52
        0304KZ6RR       0.00

Any help/direction is greatly appreciated. 

Thank you very much and have a great day!

Jim