리트코드(LeetCode) SQL 문제풀이 - 175. Combine Two Tables

MySQL 문제 175. Combine Two Tables

 

# 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