https://leetcode.com/problems/combine-two-tables/
Combine Two Tables - LeetCode
Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.
leetcode.com
personId로 조인하는 문제
outer join을 하면 된다.
SELECT firstName, lastName, city, state
FROM Person p LEFT JOIN Address a
ON p.personId = a.personId
;
'Programming > LeetCode' 카테고리의 다른 글
| [LeetCode] Employees Earning More Than Their Managers (0) | 2022.03.31 |
|---|---|
| [LeetCode] Consecutive Numbers (MySQL) (0) | 2022.03.31 |
| [LeetCode] Search a 2D Matrix (0) | 2022.03.30 |
| [LeetCode] Design Circular Queue (스택으로 원형 큐 구현) (0) | 2022.03.29 |
| [LeetCode] Implement Queue using Stacks(스택으로 큐 구현) (0) | 2022.03.29 |
댓글