Leetcode 175 组合两个表

题目:175. 组合两个表

我的解答

1
2
3
# Write your MySQL query statement below 
SELECT FirstName AS firstName, LastName AS lastName, City AS city, State AS state 
From Person LEFT OUTER JOIN Address ON Person.PersonId = Address.PersonId;