select e.empno, e.ename, e.job, e.sal from emp e where e.DEPTNO IN (select DEPTNO from DEPT e2 where e2.LOC = 'CHICAGO')
INNER-JOIN
select emp.ename,emp.deptno, emp.job,dept.loc ,dept.dname FROM EMP inner join dept on emp.deptno = dept.deptno where dept.loc = 'CHICAGO'
ORACLE INNER-JOIN
INNER-JOINS