Add: Combine Two Tables

Shuo · Shuo · commit af5e6780a319 · 2020-01-09T10:14:29.000+08:00
diff --git a/problems/combine-two-tables/combine_two_tables.sql b/problems/combine-two-tables/combine_two_tables.sql
@@ -1 +1,10 @@
 # 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;
