Need help with query

[Robert]

I have two tables (classes and students). Right now, I'm generating a
report in asp that shows a list of classes, the enrollment for each
class, and how many seats are available (see query below).

SELECT classes.classid , classes.classna me, classes.maxstud ents,
classes.Active COUNT(students. class) AS countstudentscl ass,
classes.maxstud ents - COUNT(students. class) AS remain FROM classes LEFT
OUTER JOIN students ON students.class = classes.classid GROUP BY
classes.classid , classes.classna me, classes.maxstud ents ORDER BY
classes.classid

Now, I want to filter out any class that has an Active value that = 0.
I've tried inserting WHERE classes.Active <> 0 in multiple places, but
I keep getting sytax error messages.

Can anyone help me figure this out? I'm new to SQL so please forgive
me.

[Stu]

Not sure if this is an issue or not, but you're missing a comma in your
list (between the column Active and the agg function COUNT). You are
also missing the Active column in your GROUP BY clause.

SELECT classes.classid , classes.classna me, classes.maxstud ents,
classes.Active,
COUNT(students. class) AS countstudentscl ass,
classes.maxstud ents - COUNT(students. class) AS remain
FROM classes LEFT OUTER JOIN students ON students.class =
classes.classid
WHERE classes.active <>0
GROUP BY
classes.classid , classes.classna me, classes.maxstud ents, classes.Active
ORDER BY
classes.classid

HTH,
Stu