一、题目
二、思路(自己)
- 查询Person中每个人的姓、名、城市和状态。
- Person:姓、名 Address:城市、状态
- 用外连接就行了,很简单
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
on Person.PersonId=Address.PersonId;