175. Combine Two Tables

原题链接:https://leetcode.com/problems/combine-two-tables/description/
刷着算法题忽然乱入了一道数据库题目,而且灰常简单:

# Write your MySQL query statement below
select FirstName, LastName, City, State from Person p left join Address a on p.PersonId = a.PersonId;
posted @ 2018-03-22 10:19  optor  阅读(93)  评论(0编辑  收藏  举报