simple solution 🙌 | easy solution ☘️ | using LEFT JOIN and ON ✨
Code

# Code
```mysql []
select 
    p.firstName, p.lastName, 
    a.city, a.state 
from Person p
left join Address a
on p.personId = a.personId


```
['MySQL']