Union solution ||SQL
\nselect p.firstName, p.lastName, a.city, a.state\nfrom Person p, Address a\nwhere p.personId = a.personId\nunion\nselect p.firstName, p.lastName, null, null \n
```\nselect p.firstName, p.lastName, a.city, a.state\nfrom Person p, Address a\nwhere p.personId = a.personId\nunion\nselect p.firstName, p.lastName, null, null \nfrom Person p\nwhere p.personId not in (select a.personId from Address a)\n```
['MySQL']