SQLD(SQL 개발자) 기출 · JOIN

이 문제 풀어보기

1. 1.SELECT A.ID, A.NAME, B.SUBJECT
   FROM A INNER JOIN B ON A.ID = B.ID;
2. 2.SELECT A.ID, A.NAME, B.SUBJECT
   FROM A LEFT OUTER JOIN B ON A.ID = B.ID;
3. 3.SELECT A.ID, A.NAME, B.SUBJECT
   FROM A RIGHT OUTER JOIN B ON A.ID = B.ID;
4. 4.SELECT A.ID, A.NAME, B.SUBJECT
   FROM A FULL OUTER JOIN B ON A.ID = B.ID;