목록SQL 문제풀이/Leetcode (7)
취미가 좋다
175. Combine Two Tables
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 SELECT P.FirstName, P.LastName, A.City, A.State FROM Person P LEFT JOIN ADDRESS A ON P.PersonID = A.PersonID SELECT 할 때, P 혹은 A 를 입력하지 않고 그대로 FirstName, LastName, ..
SQL 문제풀이/Leetcode
2021. 8. 13. 15:09