外连接,显示两张表相交的数据,不存在数据显示null select FirstName,LastName,City,state from Person p left join Address a on p.PersonId = a.PersonId