mysql, left join
https://leetcode.com/submissions/detail/857988684/\n\n# Write your MySQL query statement below\nselect p.firstname, p.lastname, a.city, a.state\nfrom Person as 
https://leetcode.com/submissions/detail/857988684/\n```\n# Write your MySQL query statement below\nselect p.firstname, p.lastname, a.city, a.state\nfrom Person as p left join Address as a\non p.personId = a.personID\n```
['MySQL']