175. Combine Two Tables

Report each person's first name, last name, city and state. A person without an address still appears, with NULL city and state.

A LEFT JOIN keeps every row of Person. An inner join would drop people with no address.

Lesson: joins.

Solutions

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