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 = 'SALES';
2. 2.SELECT * FROM SCOTT.EMP A
   CROSS JOIN SCOTT.DEPT B
   ON (A.DEPTNO = B.DEPTNO AND
   B.DNAME = 'SALES');
3. 3.SELECT * FROM SCOTT.EMP A
   RIGHT OUTER JOIN SCOTT.DEPT B
   ON (A.DEPTNO = B.DEPTNO AND
   B.DNAME = 'SALES');
4. 4.SELECT * FROM SCOTT.EMP A
   LEFT OUTER JOIN SCOTT.DEPT B
   ON(A.DEPTNO = B.DEPTNO AND
   B.DNAME 'SALES');