So watch your capitalization carefully!


  • 1
    Q
    SELECT person.firstname,person.lastname,address.city,address.state 
    FROM person 
    LEFT JOIN address 
    ON person.personid=address.personid
    ORDER BY person.personid;
    

    ​WRONG!!!
    #注意大小写!!!

    SELECT Person.FirstName,Person.LastName,Address.City,Address.State 
    FROM Person 
    LEFT JOIN Address 
    ON Person.PersonId=Address.PersonId
    ORDER BY Person.PersonId;
    

    RIGHT!!!


Log in to reply
 

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