1
 2
 3
 4
 5
 6
 7
 8
 9
10
11

-- @Title: 组合两个表 (Combine Two Tables)
-- @Author: 15816537946@163.com
-- @Date: 2021-03-03 15:13:15
-- @Runtime: 274 ms
-- @Memory: 0 B
# Write your MySQL query statement below

select FirstName, LastName, City, State 
from Person P 
left join Address A
on P.PersonId = A.PersonId