So watch your capitalization carefully\uff01
\n\nSELECT person.firstname,person.lastname,address.city,address.state \nFROM person \nLEFT JOIN address \nON person.personid=address.personid\nORDER BY person.
\n```\nSELECT person.firstname,person.lastname,address.city,address.state \nFROM person \nLEFT JOIN address \nON person.personid=address.personid\nORDER BY person.personid;\n```\n\u200bWRONG!!!\n#\u6ce8\u610f\u5927\u5c0f\u5199\uff01\uff01\uff01\n\u200b\n```\nSELECT Person.FirstName,Person.LastName,Address.City,Address.State \nFROM Person \nLEFT JOIN Address \nON Person.PersonId=Address.PersonId\nORDER BY Person.PersonId;\n```\nRIGHT!!!
[]