List the employee names and the name of their departments.

Q. List the employee names and the name of their departments.

Consider  this table --

SALARYGRADE ( LOWSAL , HIGHSAL , GRADE )
DEPT(DEPTNO. , DEPTNAME , LOCATION)

You can understand by seeing this video ---

Answer :-

SELECT ENAME , DEPTNO FROM EMPL , DEPT
WHERE EMPL.DEPTNO = DEPT.DEPTNO;