0704 sql

175. Combine Two Tables

-- https://leetcode.com/problems/combine-two-tables/description/

select p.firstname, p.lastname, a.city, a.state
from person p
left outer join address a
on p.personid=a.personid

If the address of a personId is not present in the Address table, report null instead.