175-Combin Two Tables
2017-12-27 本文已影响10人
篮子always
语言:SQL
select a.FirstName, a.LastName, b.City, b.State from Person as a left join Address as b on a.PersonId = b.PersonId
语言:SQL
select a.FirstName, a.LastName, b.City, b.State from Person as a left join Address as b on a.PersonId = b.PersonId