Easy solution with left join
Code\n\nSELECT p.firstName, p.lastName, a.city, a.state FROM Person p\nLEFT JOIN Address a ON p.personId = a.personId\n
# Code\n```\nSELECT p.firstName, p.lastName, a.city, a.state FROM Person p\nLEFT JOIN Address a ON p.personId = a.personId\n```
['Oracle']