175. 组合两个表
解题思路
附表中值可能存在null的情况
使用outer join
select firstName, lastName, city, state
from Person
left join Address
on Person.PersonID = Address.PersonID;
175. 组合两个表
解题思路
附表中值可能存在null的情况
使用outer join
select firstName, lastName, city, state
from Person
left join Address
on Person.PersonID = Address.PersonID;