select FirstName, LastName, City, State
from Person left join Address
using (PersonId);
or
select FirstName, LastName, City, State
from Person left join Address
on Person.PersonId=Address.PersonId;
select FirstName, LastName, City, State
from Person left join Address
using (PersonId);
or
select FirstName, LastName, City, State
from Person left join Address
on Person.PersonId=Address.PersonId;