Reputation: 16
select e.EMPNO, e.EMPNAME ,e.DEPT_NO, d.DEPT_NAME FROM EMPLOYEE e , DEPARTMENT d WHERE e.DEPT_NO = d.DEPT_NO GROUP BY d.DEPT_NO;
ORA-00979: not a GROUP BY expression
Upvotes: 0
Views: 28