So watch your capitalization carefully!

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


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


Log in to reply

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