select p.firstName, p.lastName, a.city, a.state from person as p left join address as a on a.personId = p.personId W.I.P