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

[sajadsobh]

من یه دستور تودر تو می نویسم ببین جواب میده؟
اگه جواب داد و متوجه نشدین بگین توضیح بدم.

SELECT t1.ID, t1.name, SUM(t1.Bedehi) as Bedehi, SUM(t2.Padakhti) as Padakhti

FROM (

SELECT students.ID, students.name, SUM(Debts.price) as Bedehi

FROM students LEFT JOIN Debts  on students.ID = Debts.student_id

GROUP BY students.ID, students.name) as t1

LEFT JOIN

(SELECT students.ID, students.name, SUM(Receipts.price) as Padakhti

FROM students LEFT JOIN Receipts on students.ID = Receipts.student_id

GROUP BY students.ID, students.name) as t2

on t1.ID = t2.ID

GROUP BY t1.ID, t1.name

ORDER BY t1.ID