Left join


  • 0
    N
    select p.FirstName, p.LastName, a.City, a.State
    from Person p left join Address a on p.PersonId = a.PersonId
    

Log in to reply
 

Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.