[오라클/SQL] JOIN 종류 정리 : INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, Self JOIN, Multiple JOINs

1. INNER JOIN, OUTER JOIN1) INNER JOIN, OUTER JOIN의 특성 요약2) INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN의 관계3) INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN의 조회결과 레코드 비교4) 상세 페이지 링크INNER JOIN : EQUI JOIN(등가 조인)https://blog.naver.com/regenesis90/222188241512INNER JOIN : NON-EQUI JOIN(비등가 조인)https://blog.naver.com/regenesis90/222188441395OUTER JOIN : LEFT JOIN, RIGHT JOINhttps://blog.naver.com/regenesis90/222190313921OUTER JOIN : FULL JOINhttps://blog.naver.com/regenesis90/2221903859152.

Self JOIN, Multiple JOINsSelf JOIN : 1개..........