先输入要查询的内容，

firstname，lastname，city，state

A left join B 取A全部，若B没有对应的值则为null

A right join B 取B全部，若A没有对应的值为null

1
2
3
select FirstName, LastName, City, state
from PersonId left join Address
on Person.PersonId = Adderss.PersonId;