# Write your MySQL query statement below
select p.FirstName, p.LastName, a.City, a.State
from person p
left join address a
on p.PersonId = a.PersonId
09-04
156
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
08-02
1825
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
# Write your MySQL query statement below
select p.FirstName, p.LastName, a.City, a.State
from person p
left join address a
on p.PersonId = a.PersonId