leetcode 175 组合两个表

组合两个表

使用左连接 left join

select p.firstName, p.lastName, a.city, a.state 
from Person as p
left join Address as a
on a.PersonId = p.PersonId

====