simple solution
select p.FirstName, p.LastName, a.City,a.State\nfrom person as p\nleft join Address as a\non p.PersonId=a.PersonId;
select p.FirstName, p.LastName, a.City,a.State\nfrom person as p\nleft join Address as a\non p.PersonId=a.PersonId;
[]