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