175. Combine Two Tables.md

175. Combine Two Tables

Question Link

Solution

# 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 group by p.personId