组合两个表
问题:
编写一个 SQL 查询,满足条件:无论 person 是否有地址信息,都需要基于上述两表提供 person 的以下信息:
FirstName, LastName, City, State
思路:
由于题目指出地址信息可能没有,所以采用 外连接 的方法
左外连接(left outer join)
select FirstName, LastName, City, State
from Person left join Address
on Person.PersonId = Address.PersonId;
或者右外连接(right outer join)
select FirstName, LastName, City, State
from Address right join Person
on Person.PersonId = Address.PersonId;