外连接,显示两张表相交的数据,不存在数据显示null

    1. select FirstName,LastName,City,state
    2. from Person p left join Address a
    3. on p.PersonId = a.PersonId