INNER JOIN
SELECT A.name, A.age, B.school_name
FROM A INNER JOIN B ON A.school_no = B.school_no
WHERE A.seq = 10
LEFT OUTER JOIN
SELECT A.name, A.age, B.school_name
FROM A LEFT OUTER JOIN B ON A.school_no = B.school_no
WHERE A.seq = 10
RIGHT OUTER JOIN
SELECT A.name, A.age, B.school_name
FROM A RIGHT OUTER JOIN JOIN B ON A.school_no = B.school_no
WHERE A.seq = 10
'프로그래밍 > db' 카테고리의 다른 글
| [MSSQL] null값, null이 아닌 값 조회하기 (0) | 2020.12.24 |
|---|---|
| [mysql] 계정 추가하기 (create user, insert, grant all ) (0) | 2020.11.20 |