DB
[MySQL] Join
나무늘보
2021. 12. 17. 09:59
LEFT JOIN
SELECT *
FROM Table A
LEFT JOIN Table B
ON A.Key = B.key
LEFT JOIN ( IS NULL )
SELECT *
FROM Table A
LEFT JOIN Table B
ON A.Key = B.key
WHERE B.ID IS NULL순수 A의 값만 가져옵니다.