hi all
i want code to get sum of 2 columns based on PK like
first table (Doctors)
Code_pk Doctor_name
1 Ahmad
second table (doctor_payments)
code_Fk payment
1 100
1 200
third table (Doctor_amounts )
Code_fk amount
1 50
1 300
i want to show in grideview
=========================
name sum(payments) sum(amounts)
ahmad 300 350
** i write sql query but its show first sum correct and second sum not correct
=======================================
SELECT doctors.doctor_name, SUM(Doctor_Amounts.amount ) AS Expr2, SUM(Doctor_payments.payment) AS Expr1
FROM doctors LEFT OUTER JOIN Doctor_payments ON
doctors.code_pk = Doctors_payments.code_fk
LEFT OUTER JOIN
Doctor_amounts ON doctors.code = Doctor_amounts.code_fk
GROUP BY doctors.doctor_name
================