Left outer join
\nselect firstName, lastName, city, state\nfrom Person p\nleft join Address a\n    on p.personId = a.personId;\n
```\nselect firstName, lastName, city, state\nfrom Person p\nleft join Address a\n    on p.personId = a.personId;\n```
['MySQL']