LeetCode-MySQL: 175. 组合两个表
左连接查询
# Write your MySQL query statement below
select firstname, lastname, city, state from person p
left join address a on p.PersonId = a.PersonId;
LeetCode-MySQL: 175. 组合两个表
左连接查询
# Write your MySQL query statement below
select firstname, lastname, city, state from person p
left join address a on p.PersonId = a.PersonId;