LeetCode: 175. Combine Two Tables

友情支持

如果您觉得这个笔记对您有所帮助，看在D瓜哥码这么多字的辛苦上，请友情支持一下，D瓜哥感激不尽，😜

支付宝

有些打赏的朋友希望可以加个好友，欢迎关注D 瓜哥的微信公众号，这样就可以通过公众号的回复直接给我发信息。

wx jikerizhi

公众号的微信号是: jikerizhi。因为众所周知的原因，有时图片加载不出来。如果图片加载不出来可以直接通过搜索微信号来查找我的公众号。

175. Combine Two Tables

LeetCode - Combine Two Tables

Table: Person

----------------------+
| Column Name | Type    |
----------------------+
| PersonId    | int     |
| FirstName   | varchar |
| LastName    | varchar |
----------------------+
PersonId is the primary key column for this table.

Table: Address

----------------------+
| Column Name | Type    |
----------------------+
| AddressId   | int     |
| PersonId    | int     |
| City        | varchar |
| State       | varchar |
----------------------+
AddressId is the primary key column for this table.

Write a SQL query for a report that provides the following information for each person in the Person table, regardless if there is an address for each of those people:

FirstName, LastName, City, State

1
2
3
4
5
6
7
8
-- 175. Combine Two Tables
SELECT p.FirstName,
       p.LastName,
       a.City,
       a.State
FROM Person p
         LEFT JOIN Address a
                   ON p.PersonId = a.PersonId