【MySQL】【leetcode】 Combine Two Tables解题报告

来源:互联网 时间:1970-01-01

题目

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;


相关阅读:
Top