leetcode刷题175-
-
题目描述
- 实现代码
SELECT FirstName, LastName, City, State
FROM Person
LEFT OUTER JOIN Address
ON Person.PersonId = Address.PersonId;
-
SQL知识点
外联结-OUTER JOIN
SELECT FirstName, LastName, City, State
FROM Person
LEFT OUTER JOIN Address
ON Person.PersonId = Address.PersonId;