1 create table  #a  2 ( 3    ID INT, 4    CODE varchar(100), 5    Name varchar(100), 6 ) 7  8 insert #a  9 select 1,'a','扬子江'10 union all11 select 2,'a','扬子江'12 union all13 select 3,'a','扬子江'14 union all15 select 3,'a','黄浦江'16 union all17 select 3,'a','澜沧江江'18 19 select * from #a 20 21 22 create table  #b23 (24    ID INT,25    CODE varchar(100),26    Name varchar(100),27 )28 insert into #b(ID,CODE,Name) select ID,'b',Name from #a where Name='扬子江'29 30 select * from  #b