SQL Statment fun

[jrmontg]

I am having trouble figuring out this sql statement: What I need is a count of studentkey from the student table

I have

Classes

ClassDescriptionKey (PK)
CategoryKey (FK)
Description

Education

EducationKey (PK)
ClassDescriptionKey (FK)
StatusKey (FK)
Date
Time

Student

StudentKey (PK)
EducationKey (FK)
Name

This is what I am working with now

SELECT Classes.Description, Education.Date, Education.Time COUNT (Student.StudentKey) as TotalCount
FROM Classes, Education, Student
WHERE Classes.CategoryKey = 1 AND Classes.ClassDescriptionKey = Education.ClassDescriptionKey AND Education.EducationKey =
Student.EducationKey

What am I doing wrong?

Thanks

[bastien]

What is the error? You forgot to mention that...

From your code, you are missing a comma between the word Education.Time and COUNT

SELECT Classes.Description, Education.Date, Education.Time, COUNT (Student.StudentKey) as TotalCount 
FROM Classes, Education, Student 
WHERE Classes.CategoryKey = 1 AND Classes.ClassDescriptionKey = Education.ClassDescriptionKey AND Education.EducationKey = 
Student.EducationKey