Запрос

Проблема такая нужно добавить в запрос еще один запрос чтобы получился один запрос а не два

этот запрос работает

сюда надо добавить еще один запрос

$query = "SELECT Faculties.Faculty,

Specialities.Speciality,

Specialities.id,

COUNT(Results.id) AS ExamsCount,

st.StudentCount

FROM Results INNER JOIN

Curriculum ON Results.Subject =Curriculum.id INNER JOIN

Specialities ON Curriculum.Speciality =Specialities.id INNER JOIN

Faculties ON Specialities.Faculty =Faculties.id inner join

(SELECT

Faculties.id as facid,

Specialities.id as specid ,

COUNT(Students.id) AS StudentCount

FROM Students INNER JOIN

Specializations ON Students.Specialization = Specializations.id INNER JOIN

Specialities ON Specializations.Speciality = Specialities.id INNER JOIN

Faculties ON Specialities.Faculty =Faculties.id

WHERE Students.Status =1

GROUP BY Faculties.id, Specialities.id

) st on st.facid = Faculties.id and st.specid=Specialities.id

WHERE Results.Report =1

GROUP BY Faculties.Faculty, Specialities.Speciality,Specialities.id,st.StudentCount

ORDER BY Faculties.Faculty, Specialities.Speciality";

вот этот

Faculties.Faculty,Specialities.Speciality,Specialities.id,Specializati ons.Speciality,Specializations.id,Students.Specialization,Students.id, COUNT(ProgressInStudy.id) AS [Count]

FROM ProgressInStudy INNER JOIN

Students ON ProgressInStudy.Student = Students.id INNER JOIN

Specializations ON Students.Specialization = Specializations.id INNER JOIN

Specialities ON Specializations.Speciality = Specialities.id INNER JOIN

Faculties ON Specialities.Faculty =Faculties.id

WHERE ProgressInStudy.Report = 1

GROUP BY Faculties.Faculty, Specialities.Speciality,Specialities.id,Specializations.Speciality,Spe cializations.id,Students.Specialization,Students.id

ORDER BY Faculties.Faculty, Specialities.Speciality

";