https://leetcode.com/problems/combine-two-tables/
Combine 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 are the primary key column for this table.
Write a SQL query for a report this provides the following information for each person in the person table, regardless if There is a address for each of those people:
FirstName, LastName, city, state
Select P.firstname,p.lastname,a.city,a.state from Person as P left join Address as a on p.personid = A.personid;
Leetcode 175 Combine Tables Mysql,left Join difficulty: 0