leetcode数据库的题目,组合两个表,使用left join查询。
select p.FirstName,p.LastName,a.City,a.State from Person p left join Address a on p.PersonId = a.PersonId;
leetcode数据库的题目,组合两个表,使用left join查询。
select p.FirstName,p.LastName,a.City,a.State from Person p left join Address a on p.PersonId = a.PersonId;