Easiest Solution..No advance SQL required✅
```\n--Just use Join\nSELECT firstName,lastName,city,state FROM\nPerson LEFT OUTER JOIN Address ON\nPerson.personId=Address.personId;\n
```\n--Just use Join\nSELECT firstName,lastName,city,state FROM\nPerson LEFT OUTER JOIN Address ON\nPerson.personId=Address.personId;\n
['MySQL']