Can someone please tell me why I get an error message on this query that JobType is not included in the first query?
SELECT Department.DepartmentName, Employee.EmployeeNumber, Employee.LastName, Employee.FirstName, 'Regular' AS JobType, Sum(Time.Hours) AS SumOfHours
FROM Department INNER JOIN...