Clean Solution
\nSELECT p.firstName,\n       p.lastName, \n       a.city, \n       a.state \n  FROM Person p \n  LEFT JOIN Address a ON a.personId = p.personId\n
```\nSELECT p.firstName,\n       p.lastName, \n       a.city, \n       a.state \n  FROM Person p \n  LEFT JOIN Address a ON a.personId = p.personId\n```
['MySQL', 'Oracle', 'MS SQL Server']