select dept.dname,wm_concat(emp.ename) from dept,emp where dept.deptno=emp.deptno group by dept.dname
