[Leetcode] Combine Two Tables

문제 링크

정답

SELECT P.firstName, P.lastName, A.city, A.state
FROM Person P
LEFT JOIN Address A
ON P.personId = A.personId

✅ Point

• Address 가 없는 경우엔 null 처리 -> LEFT JOIN