Really cute solution
```\nSELECT Person.FirstName, Person.LastName, Address.City, Address.State\nFROM Person LEFT JOIN Address\non Person.PersonId = Address.PersonId
```\nSELECT Person.FirstName, Person.LastName, Address.City, Address.State\nFROM Person LEFT JOIN Address\non Person.PersonId = Address.PersonId
['MySQL']