• 使用join操作连接表

使用join操作连接表

select FirstName, LastName, City, State
from Person left join Address
on Person.PersonId = Address.PersonId;