At the end of my simple query, I have this group by clause that is illegal. How can I do this legally?
WHERE IYR(CHKDATE) IN (2004, 2005, 2006, 2007) GROUP BY IYR(CHKDATE), PRHIST.EID, PRHIST.LNAME, EMPLOYEE.FIRSTNAME Damon J. Gray Anvil Corporation Business Services (360) 937-0770

