SQL_SUBQUERY_INNERJOIN1
REPLACE JOINS WITH SUB QUERIES
SCRIPTS

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 SUB QUERIES

ORACLE INNER-JOIN

POSTGRESQL SUB QUERIES

INNER-JOINS

MYSQL SUB QERIES

 

INNER-JOINS