175.组合两个表sql
用到的表和数据SQL:spa
Create table Person (PersonId int,FirstName varchar(255), LastName varchar(255)); Create table Address (AddressId int,PersonId int, City varchar(255), State varchar(255)); Truncate table Person; insert into Person (PersonId, LastName,FirstName) values ('1', 'Wang', 'Allen'); Truncate table Address; insert into Address (AddressId, PersonId,City, State) values ('1', '2', 'New York City', 'New York');
答案:3d
此题至关因而把两个表的数据经过PersonId链接在一块儿,组合成一张新表code
select p.FirstName,p.LastName,a.City,a.State from Person p left join Address a on a.PersonId =p.PersonId
写的比较粗糙,有不理解的能够扫描二维码加QQ群找我解答。blog