175. Combine Two Tables

problem

solution

JOIN

# Write your MySQL query statement below

select a.firstName, a.lastName, b.city, b.state
from Person as a
LEFT JOIN Address as b
ON a.personId = b.personId
;