- left (outer) join
- right (outer) join
괄호는 생략가능.
User Table
id, name
1 , A
2 , B
Customer Table
id, name, date
2, B , 24-01-30
3, C , 24-01-29
select *
from user left join customer
on user.id = customer.id;
해당 테이블 두개를 left join을 했을때,
user user customer
id, name, id, name, date
1 , A , NULL, NULL, NULL
2 , B , 2, B , 24-01-30
이렇게 나온다.
select *
from user right join customer
on user.id = customer.id;
해당 테이블 두개를 right join을 했을때,
user user customer
id, name, id, name, date
2 , B ,2 , B , 24-01-30
NULL,NULL,3, C , 24-01-29
이렇게 나온다.
