Leetcode 175 Combine Tables Mysql,left Join difficulty: 0

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