select FirstName, LastName,City, State
from Person
left join Address on Person.PersonId = Address.PersonId;
175. Combine Two Tables
https://github.com/qixing810/leetcode_database
select FirstName, LastName,City, State
from Person
left join Address on Person.PersonId = Address.PersonId;