a query to display the last name, department number, and department name for all employees

Bandi
Posted by Bandi under Sql Server category on | Points: 40 | Views : 180
SELECT E.ENAME,E.DEPTNO,D.DNAME
FROM EMP E,DEPT D
WHERE E.DEPTNO=D.DEPTNO

Comments or Responses

Login to post response