LeetCode刷题之数据库-175. 组合两个表

175. 组合两个表
难度：简单
https://leetcode-cn.com/problems/combine-two-tables/

1. 题目
   
   
2. 解题过程：

# Write your MySQL query statement below
select
    p.FirstName,
    p.LastName,
    a.City,
    a.State
from
    Person p left join Address a
    on p.PersonId=a.PersonId;