SQLD(SQL 개발자) 기출 · JOIN

이 문제 풀어보기

1. 1.SELECT *
   FROM HR.EMPLOYEES A
   INNER JOIN HR.DEPARTMENTS B
   ON (DEPARTMENT_ID)
   WHERE A.DEPARTMENT_ID = 90;
2. 2.SELECT *
   FROM HR.EMPLOYEES A
   INNER JOIN HR.DEPARTMENTS B
   ON A.DEPARTMENT_ID = B.DEPARTMENT_ID
   WHERE A.DEPARTMENT_ID = 90;
3. 3.SELECT *
   FROM HR.EMPLOYEES A
   INNER JOIN HR.DEPARTMENTS B
   USING (DEPARTMENT_ID)
   WHERE DEPARTMENT_ID = 90;
4. 4.SELECT *
   FROM HR.EMPLOYEES A
   NATURAL JOIN HR.DEPARTMENTS B
   WHERE DEPARTMENT_ID = 90;