原题链接: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;
原题链接: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;