Dear all



I am trying to create view with this command but it is give me error



create or replace view emp_dept_view (emp_name,department,department_id)

as select e.name, d.dept_name, d.dept_id

from employee e, department d

group by d.dept_name ;



Error report:

SQL Error: ORA-00979: not a GROUP BY expression



Same if I use group by d.dept_name ;



Any advice?????


Oracle LazyDBA home page