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

 

Reply via email to