>Hi everyone,
>
>I am running the following select statement:
>

>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 1

>
>
>If I join two tables I have the right result but with three tables.
>Is there a problem joining more than two tables and using group by?
>
>Thanks.

No. What data you have in these tables and what result you expect?

Also are you sure that for each cTrans_pk you have at least one record in Payments and one record in Charges tables?