>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 AND Employees.IsActive = True ) 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; >>