我的LeetCode代码仓:https://github.com/617076674/LeetCode
原题链接:https://leetcode-cn.com/problems/combine-two-tables/description/
题目描述:
知识点:LEFT JOIN连接查询
思路:LEFT JOIN连接查询
LEFT JOIN 关键字会从左表那里返回所有的行,即使在右表中没有匹配的行。根据题目要求,我们将Person表作为左表,Address表作为右表。
SQL语句:
SELECT FirstName, LastName, City, State FROM Person LEFT JOIN Address ON Person.PersonId = Address.PersonId;
LeetCode解题报告: