【MySQL】【leetcode】 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 belowselect FirstName, LastName, City, State from Person left outer join Address on Person.PersonID = Address.PersonID;