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.