Hi datasp, Apologize for late reply. What is happening the next A of Table1? no action require as Table_B no more A group Is it to be ignored and go to B of Table 1? Yes, next will be cross match between Table_A and Table_B for B group. Added balance_extra into table for more understanding, thank you Sg_a Key_a Key_b Balance_Extra actual_transfer A KEY1 KEY3 50 -10 = 40 10 A KEY1 KEY4 40 - 25 = 15 25 A KEY1 KEY5 15 - 15 = 0(Key 1 no more number, next use Key 2) 15 A KEY2 KEY5 80 - 20, stop as table_B no more group for A 20 B KEY6 KEY7 1000 - 200 = 800 200 B KEY6 KEY8 800 - 700 = 100, stop as table_B no more group for B 700 C KEY9 KEY12 10 - 10 = 0, (Key 9 no more number, next use Key 10) 10 C KEY10 KEY12 5 - 5 = 0, (Key 10 no more number, next use Key 11) 5 C KEY11 KEY12 500 - 5 = 495 5 C KEY11 KEY13 495 - 400 = 95 400 C KEY11 KEY14 95 - 10 = 85 10 C KEY11 KEY15 85 - 50 = 35, stop for as table_B no more group for C 50
... View more