LeetCode/src/easy/CombineTowTables.sql at master · chenyiAlone/LeetCode · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
/*
 *  No.175 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
 */

# Write your MySQL query statement below
SELECT FirstName, LastName, City, State FROM Person p
LEFT JOIN Address a ON p.`PersonId` = a.`PersonId`;