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

If we don't have records in Payments or Charges, should this select be re-written to use LEFT JOIN and NVL instead?

Thanks.