Inner Select statements

[mike55]

Hi all

 

am attempting to do an inner select statement on a table, the table structure is as follows:

StudentID, Course_Name, Year

 

What i want to do is to count the no. of students on each course. The query must be setup in such a way that we get the course name from the table itself.

 

SELECT Distinct(Course_Name), Count(StudentID) as Population

FROM Details

where (course_Name) = (Select Distinct(Course_Name) From Details)

 

But this statement doesn't seem to work...any suggestions.

 

Mike55

[Nerseus]

You need the "GROUP BY" clause of SQL:

 

SELECT Course_Name, Count(StudentID) as Population

FROM Details

GROUP BY Course_Name

 

 

The group by will give you a distinct list by its very nature.

 

-ner