2018-11-24 组合两个表
2018-11-24 本文已影响0人
天际神游
题目:
175. 组合两个表
解法:
select FirstName, LastName, City, State
from Address as a
right join Person as p
on a.PersonId = p.PersonId
select FirstName, LastName, City, State
from Address as a
right join Person as p
on a.PersonId = p.PersonId