leetcode175 组合两个表 Combine Two Tables
创建表和数据:
drop table Person; Create table Person (PersonId int,FirstName varchar(255), LastName varchar(255)); drop table Address; Create table Address (AddressId int,PersonId int, City varchar(255), State varchar(255)); insert into Person (PersonId, LastName,FirstName) values ('1', 'Wang', 'Allen'); insert into Address (AddressId, PersonId,City, State) values ('1', '2', 'New York City', 'New York');
解法:
select FirstName, LastName, City, State from Person P left join Address Ad on (P.PersonId = Ad.PersonId);