I'm trying to add
WHERE e.IsActive to this query
SELECT d.GroupId,
Sum(d.cert_complete) AS SumOfcert_complete,
Count(d.cert_complete) AS CountOfcert_complete
FROM (SELECT DISTINCT s.GroupId, e.EmployeeID, IIf(e.Certified Is Null,0,1) AS cert_complete
FROM ((Stores AS s
INNER JOIN EmployeeStores AS es ON s.StoreId=es.StoreId)
INNER JOIN Employees AS e ON es.EmployeeId=e.EmployeeID)
INNER JOIN Titles AS t ON e.TitleId=t.TitleId WHERE t.IsManager=True) as d
WHERE e.IsActive
GROUP BY d.GroupId
UNION ALL SELECT 0 as GroupId,
Sum(d.cert_complete) AS SumOfcert_complete,
Count(d.cert_complete) AS CountOfcert_complete
FROM (SELECT DISTINCT s.GroupId, e.EmployeeID, IIf(e.Certified Is Null,0,1) AS cert_complete
FROM ((Stores AS s
INNER JOIN EmployeeStores AS es ON s.StoreId=es.StoreId)
INNER JOIN Employees AS e ON es.EmployeeId=e.EmployeeID)
INNER JOIN Titles AS t ON e.TitleId=t.TitleId WHERE t.IsManager=True) AS d
WHERE e.IsActiveWhen I add the WHERE clause and run it, I get prompted for "e.IsActive".
What am I doing wrong here???>?
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
