Simple left join solution
\nselect FirstName, LastName, City, State\nfrom Person\nleft join Address\non Person.PersonId = Address.PersonId\n\n\nLike it ? please upvote !
```\nselect FirstName, LastName, City, State\nfrom Person\nleft join Address\non Person.PersonId = Address.PersonId\n```\n\n**Like it ? please upvote !**
['MySQL']