SELECT Employees.FirstName, Employees.LastName, Employees.IsActive, Classes.ClassId, Classes.ClassName, EmployeeClasses.AttendedDate, EmployeeClasses.Score, Stores.StoreId, Stores.StoreNumber, Stores.StoreNumber+" - "+Stores.StoreName AS StoreName, [FirstName] + " " + [LastName] + " - " + Titles.Title AS FullName FROM (((Classes INNER JOIN (Employees INNER JOIN EmployeeClasses ON Employees.EmployeeId=EmployeeClasses.EmployeeId) ON ClassId=EmployeeClasses.ClassId) INNER JOIN EmployeeStores ON Employees.EmployeeId=EmployeeStores.EmployeeId) INNER JOIN Stores ON EmployeeStores.StoreId=Stores.StoreId) LEFT JOIN Titles ON Employees.TitleId=Titles.TitleId ORDER BY StoreNumber;But I still for the life of me cannot get it to accept "Employees.IsActive=True" anwhere. My problem is that I can't seem to understand this nested JOIN syntax. It doesn't make sense..