问题连接：175. 组合两个表
Question:
表1: Person
1
2
3
4
5
6
7
8
|
+-------------+---------+
| 列名 | 类型 |
+-------------+---------+
| PersonId | int |
| FirstName | varchar |
| LastName | varchar |
+-------------+---------+
PersonId 是上表主键
|
表2: Address
1
2
3
4
5
6
7
8
9
|
+-------------+---------+
| 列名 | 类型 |
+-------------+---------+
| AddressId | int |
| PersonId | int |
| City | varchar |
| State | varchar |
+-------------+---------+
AddressId 是上表主键
|
编写一个 SQL 查询，满足条件：无论 person 是否有地址信息，都需要基于上述两表提供 person 的以下信息：
1
|
FirstName, LastName, City, State
|
Answer:
1
2
3
4
5
6
7
8
9
10
|
# outer join 和 inner join 的区别
# 为什么默认的是 inner join
# 参考文章地址 https://www.cnblogs.com/toSeeMyDream/p/6843984.html
select Person.FirstName, Person.LastName, Address.City, Address.State
from Person
left join Address
on Person.PersonId = Address.PersonId;
|
~~~
近期评论