MySQL | USING SIMPLE L-R JOIN
select  \nFirstName,\nLastName, \nCity, State from Person p \nleft join Address a on p.PersonId = a.PersonId
select  \nFirstName,\nLastName, \nCity, State from Person p \nleft join Address a on p.PersonId = a.PersonId
[]