力扣刷题笔记——175. 组合两个表

175. 组合两个表

使用left join

# Write your MySQL query statement below
select firstName, lastName, city, state from Person left join Address on Person.personId = Address.personId;