데이터베이스
JOIN 간단 정리
EL2A
2017. 3. 23. 19:45
JOIN 종류 4가지
1. LEFT JOIN
A : 1,2,3
B : 1,2.4
Result => 1,2,3
2. RIGHT JOIN
A : 1,2,3
B : 1,2.4
Result => 1,2,4
3. INNER JOIN
A : 1,2,3
B : 1,2.4
Result => 1,2
4. FULL OUTER JOIN
A : 1,2,3
B : 1,2.4
Result => 1,2,3,4