175. Combine Two Tables

MySQL

# Write your MySQL query statement below
SELECT Person.firstName, Person.lastName, Address.city, Address.state
FROM Person LEFT JOIN Address 
on Person.personId = Address.personId;