>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?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.