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;
Post a Comment
You can help us by Clicking on ads. ^_^
Please do not send spam comment : )