MySQL Solution
\nselect firstname, lastname, city, state \nfrom person left join address\non person.personid=address.personid;\n
```\nselect firstname, lastname, city, state \nfrom person left join address\non person.personid=address.personid;\n```
['MySQL']