Hi,
does anybody know, why my comment does not work?
SELECT Employee.Lastname, Employee.Firstnme, EMP_ACT.Projno
FROM Employee Join EMP_ACT On Employee.Empno = EMP_Act.Empno
GROUP BY EMP_ACT.Projno
HAVING COUNT(*) >= 3
this is the error:
SQL0119N An expression starting with "FIRSTNME" specified in a SELECT clause,
HAVING clause, or ORDER BY clause is not specified in the GROUP BY clause or
it is in a SELECT clause, HAVING clause, or ORDER BY clause with a column
function and no GROUP BY clause is specified. SQLSTATE=42803
thanks
group by does not work
Posted - 04/22/2012 : 16:58:30
