Combine Two Tables

Problem

Given two tables Person and Address, write a SQL query to report the first name, last name, city, and state of each person.

If the address of a personId is not present in the Address table, report null for city and state.

Return the result table in any order.

Person table

Address table

Approach Hints

• Use LEFT JOIN from Person to Address on personId. INNER JOIN would drop persons without an address.
• SQL skeleton:

SELECT p.firstName, p.lastName, a.city, a.state
FROM Person p
LEFT JOIN Address a ON p.personId = a.personId;