SQL Easy sol
\n# Write your MySQL query statement below\n# method 1\n# note : we are using left join because we have to access all the rows from the person table. vice versa
```\n# Write your MySQL query statement below\n# method 1\n# note : we are using left join because we have to access all the rows from the person table. vice versa for right. \nselect person.firstName, person.lastName, Address.city, Address.state\nfrom person\nLEFT JOIN Address \non person.personId=Address.personId;\n# method 2\nselect firstName, lastName, city, state\nfrom person\nLEFT JOIN Address \non person.personId=Address.personId;\n```
['MySQL']