SQLD(SQL 개발자) 기출 · JOIN

이 문제 풀어보기

1. 1.SELECT * FROM SCOTT.EMP A INNER JOIN SCOTT.DEPT B
   ON A.DEPTNO = B.DEPTNO WHERE 1=1
   AND B.DNAME = 'KIM';
2. 2.SELECT * FROM SCOTT.EMP A INNER JOIN SCOTT.DEPT B
   ON (A.DEPTNO = B.DEPTNO
   AND B.DNAME = 'KIM') WHERE 1=1;
3. 3.SELECT * FROM SCOTT.EMP A RIGHT OUTER JOIN SCOTT.DEPT B
   ON (A.DEPTNO = B.DEPTNO
   AND B.DNAME = 'KIM') WHERE 1=1;
4. 4.SELECT * FROM SCOTT.EMP A LEFT OUTER JOIN SCOTT.DEPT B
   ON (A.DEPTNO = B.DEPTNO
   AND B.DNAME = 'KIM') ;