【175】组合两个表(Combine Two Tables)

SQL架构

SQL数据

编写一个 SQL 查询，满足条件：无论 person 是否有地址信息，都需要基于上述两表提供 person 的以下信息：

FirstName, LastName, City, State

基本题，考察join的使用
下面展示四种

1.LEFT JOIN

SELECT
	FirstName, LastName, City, State
FROM
	Address a LEFT JOIN Person p
ON
	a.PersonId = p.PersonId

结果

2.RIGHT JOIN

SELECT
	FirstName, LastName, City, State
FROM
	Address a RIGHT JOIN Person p
ON
	a.PersonId = p.PersonId

结果

3.FULL JOIN

SELECT
	FirstName, LastName, City, State
FROM
	Address a FULL JOIN Person p
ON
	a.PersonId = p.PersonId

结果

4.JOIN

SELECT
	FirstName, LastName, City, State
FROM
	Address a JOIN Person p
ON
	a.PersonId = p.PersonId

结果