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 all 11 select 2,'a','扬子江' 12 union all 13 select 3,'a','扬子江' 14 union all 15 select 3,'a','黄浦江' 16 union all 17 select 3,'a','澜沧江江' 18 19 select * from #a 20 21 22 create table #b 23 ( 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
