Select Trans.cTrans_fk, Sum(Payments.yAmount_paid) as yAmount_paid, ; Sum(Charges.yCharges_amount) as yCharges_amount ; from Trans inner join Payments ; on Trans.cTrans_pk = Payments.cTrans_fk ; inner join Charges ; on Trans.cTrans_pk = Charges.cTrans_fk ; group by 1If I join two tables I have the right result but with three tables.