Simple SQL Solution : LEFT JOIN
Code\n\n# Write your MySQL query statement below\nSELECT\n  p.firstName,\n  p.lastName,\n  a.city,\n  a.state\nFROM Person p\nLEFT JOIN Address a\nON p.personId
# Code\n```\n# Write your MySQL query statement below\nSELECT\n  p.firstName,\n  p.lastName,\n  a.city,\n  a.state\nFROM Person p\nLEFT JOIN Address a\nON p.personId = a.personId;\n\n```
['MySQL']