left outer join versus left join


  • 0
    P

    I heard they are same but my query is failing with left outer join because of TLE -

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

    The query with left join passes -

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

    Can you help me understand?


Log in to reply
 

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