استخراج چند فیلد از چند جدول

[sajadsobh]

از پرانتز استفاده کنین بینین با INNER JOIN جواب میده؟

SELECT students.ID, students.fName, students.lName,  SUM(Receipts.price) as Padakhti,  SUM(Debts.price) as Bedehi

FROM (students INNER JOIN Debts on students.id = Debts.student_id)  INNER JOIN Receipts on students.id = Receipts.student_id

GROUP BY students.ID, students.fName, students.lName, students.National_Num, students.stunum 

ORDER BY ID