easy to understand - mysql (Left Join)
\n\n# Code\n\n# Write your MySQL query statement below\nSELECT p.firstName,p.lastName,a.city,a.state FROM Person as P LEFT JOIN Address as a on p.personId=a.per
\n\n# Code\n```\n# Write your MySQL query statement below\nSELECT p.firstName,p.lastName,a.city,a.state FROM Person as P LEFT JOIN Address as a on p.personId=a.personId;\n\n```
['MySQL']