SQLD(SQL 개발자) 기출 · JOIN

이 문제 풀어보기

1. 1.SELECT E.EMPNO, E.DEPTNO, D.DAME FROM EMP E
   INNER JOIN DEPT D ON (E.DEPTNO = D.DEPTNO);
2. 2.SELECT * FROM DEPT JOIN DEPT_TEMP USING (DEPTNO);
3. 3.SELECT EMP.DEPTNO, EMPNO, ENAME, DNAME FROM EMP NATURAL JOIN DEPT;
4. 4.SELECT * FROM EMP a INNER JOIN DEPT b ON a.DEPTNO = b.DEPTNO;