Sql连接多个表返回两列的产品(Sql Joins on multiple table returning product of two columns)

 我试图在asp.net中生成一个sql server数据库的报告，我得到一些列的结果作为两列的产品。 这是代码 
 
   comm.CommandText = "SELECT Count(Courses.CourseID) AS CourseCount, Count(Students.StudentID) AS StudentCount, Schools.Name, Schools.StartDate, Schools.SchoolFees " +
                "FROM Schools" +
                "LEFT JOIN Courses ON (Schools.SchoolID = Courses.SchoolID)" +
                "LEFT JOIN Students ON (Schools.SchoolID = Students.SchoolID) " +
                "WHERE Schools.Active = 1 " +
                "GROUP BY Schools.Name, Schools.StartDate, Schools.SchoolFees";
 
 当我运行代码时，显示结果，但“CourseCount”和“StudentCount”的列显示的值是每个列的乘积。 “CourseCount”通常为288，“StudentCount”为38，但是当我运行代码时，“CourseCount”和“StudentCount”都显示10944，即38 x 288。 
 
 无论如何，我可以让他们显示正确的值？ 

I am trying to generate a report on a sql server database in asp.net and I am getting the results of some columns as a product of two columns. Here is the code
 
   comm.CommandText = "SELECT Count(Courses.CourseID) AS CourseCount, Count(Students.StudentID) AS StudentCount, Schools.Name, Schools.StartDate, Schools.SchoolFees " +
                "FROM Schools" +
                "LEFT JOIN Courses ON (Schools.SchoolID = Courses.SchoolID)" +
                "LEFT JOIN Students ON (Schools.SchoolID = Students.SchoolID) " +
                "WHERE Schools.Active = 1 " +
                "GROUP BY Schools.Name, Schools.StartDate, Schools.SchoolFees";
 
When I run the code, the result displays, but the columns for "CourseCount" and "StudentCount" display a value that is a product of each individual column. "CourseCount" is normally 288 and "StudentCount" is 38 but when I run the code, both "CourseCount" and "StudentCount" display 10944 which is 38 x 288.
 
Anyway I can make them display the correct values?

原文：https://stackoverflow.com/questions/37052141