select FirstName, LastName,City, State from Personleft join Address on Person.PersonId = Address.PersonId;