-
Notifications
You must be signed in to change notification settings - Fork 2
/
combine_two_tables.sql
35 lines (28 loc) · 996 Bytes
/
combine_two_tables.sql
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
/*
see https://leetcode.com/problems/combine-two-tables/description/
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
F!hKw<t*C5)&
*/
# Write your MySQL query statement below
Select Person.FirstName, Person.LastName, Address.City, Address.State
From Person Left Join Address On (Person.PersonId = Address.PersonId)