mysql新手上路,根据秦路大大的推荐,在 leetcode上刷刷题,第一站是easy题: Combine Two Tables
首先由 combine 可知需要用 join 来联接,重点是 for each person in the Person table,所以应当以Person表为主表,即采用 left join 来联接。
SELECT Person.FirstName, Person.LastName, Address.City, Address.State FROM Person LEFT JOIN Address on Person.PersonId = Address.PersonId |