ice rabbit programming

[LeetCode] Combine Two Tables 본문

PS/LeetCode

[LeetCode] Combine Two Tables

판교토끼 2020. 4. 27. 21:02
728x90

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

# Write your MySQL query statement below
SELECT Person.FirstName, Person.LastName, Address.City, Address.State
From Person
LEFT JOIN Address
ON Person.PersonId=Address.PersonId;

2020/04/26 - [PS/LeetCode] - [LeetCode] Customers Who Never Order

 

[LeetCode] Customers Who Never Order

https://leetcode.com/problems/customers-who-never-order/ Customers Who Never Order - LeetCode Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and..

icerabbit.tistory.com

직전에 올렸던 문제의 하위호환 격인 문제이다. LEFT JOIN을 사용하는 문제였다.

728x90
저작자표시 비영리 (새창열림)

'PS > LeetCode' 카테고리의 다른 글

[LeetCode] Invert Binary Tree  (0) 2020.04.27
[LeetCode] Reverse Linked List  (0) 2020.04.27
[LeetCode] Customers Who Never Order  (0) 2020.04.26
[LeetCode] Add Binary  (0) 2020.04.23
[LeetCode] Same Tree  (0) 2020.04.22
'PS/LeetCode' Related Articles more