* Sum tableA Select inv_cd, sum(balance) as balance, ; sum(interest) as interest, discount ; from tableA ; Group By inv_cd Into Cursor cursorA1 * Sum tableB Select inv_cd, sum(balance) as balance, ; sum(interest) as interest, premium ; from tableB ; Group By inv_cd Into Cursor cursorB1 * Sum tableA + tableB Select A.inv_cd, (A.balance + B.balance) as balance, ; A.discount, B.premium ; from cursorA1 A Inner Join cursorB1 B On A.invcd == B.invcd ; Group By inv_cd Into Cursor cursorC && Would be Left Join && Would be Into Table tableCI do 3 select's because I thinked that your tables can have more one record for each inv_cd.