返回首页

亲爱的朋友,

在这里,我想找到比率在sqlquery.In我的项目我想实现的学生和工作人员的比率在Perticular区

因此,IAM sucess这个:
我的输出:

txtDistName      intStaff   intStudents

Zanzibar Urban   212130     168
所以现在我笏显示的intsatff的比例和intStudents的
{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

回答

评论会员:d 时间:2