赞
踩
175. 组合两个表
难度:简单
https://leetcode-cn.com/problems/combine-two-tables/
# Write your MySQL query statement below
select
p.FirstName,
p.LastName,
a.City,
a.State
from
Person p left join Address a
on p.PersonId=a.PersonId;
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。