亲爱的朋友,
在这里,我想找到比率在sqlquery.In我的项目我想实现的学生和工作人员的比率在Perticular区
因此,IAM sucess这个:
我的输出:
所以现在我笏显示的intsatff的比例和intStudents的txtDistName intStaff intStudents
Zanzibar Urban 212130 168
{C}
所以我想,Coloumns
口粮
IAM发送我的查询示例:
的问候,SELECT ntblDistrict_1.txtDistrictName, SUM(tblSummaryStudents.intMale + tblSummaryStudents.intFemale) AS intStudents,
SUM(tblSummaryOthers.intTeachersMale + tblSummaryOthers.intTeachersFemale) AS intStaff
FROM ntblDistrict AS ntblDistrict_1 INNER JOIN
ntblPrimarySchoolList ON ntblDistrict_1.intDistrictID = ntblPrimarySchoolList.intDistrictID INNER JOIN
tblSchool ON ntblPrimarySchoolList.intPrimaryListID = tblSchool.intPrimaryListID INNER JOIN
tblSummaryOthers ON tblSchool.intSchoolID = tblSummaryOthers.intSchoolID INNER JOIN
tblSummaryStudents ON tblSchool.intSchoolID = tblSummaryStudents.intSchoolID
WHERE (ntblDistrict_1.intDistrictID IN
(SELECT intDistrictID
FROM ntblDistrict AS ntblDistrict
WHERE (intDistrictID = 9)))
GROUP BY ntblDistrict_1.txtDistrictName
Anilkumar.D