728x90
https://leetcode.com/problems/combine-two-tables/
SELECT
p.firstName, p.lastName, a.city, a.state
FROM Person p
LEFT JOIN Address a
ON p.personId = a.personId;728x90
'IT > 코딩테스트' 카테고리의 다른 글
| [Leetcode] 1523. Count Odd Numbers in an Interval Range (0) | 2023.08.18 |
|---|---|
| [Leetcode] 2278. Percentage of Letter in String (0) | 2023.08.16 |
| [Leetcode] 2042. Check if Numbers Are Ascending in a Sentence (0) | 2023.08.14 |
| [Leetcode] 27. Remove Element (0) | 2023.08.11 |
| [Leetcode] 383. Ransom Note (0) | 2023.08.11 |