Over my SQL head

[funderburgh]

I have a report that show what students are in what classes. the student data and the class records are in separate tables. the query for the report looks like this:

SELECT Classes.[Class Name], Classes.[School Year], Classes.[Teacher Name], Classes.Period, Classes.Days, Classes.[Room Number], Students.[First Name], Students.[Last Name], [Class Days].[Day Order], Students.[Middle School?]
FROM [Class Days] INNER JOIN (Students INNER JOIN Classes ON Students.[StudentID] = Classes.[ID]) ON [Class Days].[Class Days] = Classes.Days;

I have now added a boolean field to the student table "Inactive", I am using to omit certian students from reports and other functions, but I am having the devil of a time figuring out where to put

WHERE Student.Inactive = 'false'

in this query. Any suggestions would be appreciated - thanks.

 

[plog]

SELECT -> FROM -> WHERE -> GROUP BY -> HAVING -> ORDER BY

Put it after the FROM clause.