select identity(int,1,1) as ID,* into #T2 from T2
select identity(int,1,1) as ID,* into #T3 from T3insert into T1(学号,姓名,机号)
select
a.学号,a.姓名,b.机号1
from
#T2 a,#T3 b
where
a.ID=b.ID
select identity(int,1,1) as ID,* into #T3 from T3insert into T1(学号,姓名,机号)
select
a.学号,a.姓名,b.机号1
from
#T2 a,#T3 b
where
a.ID=b.ID
--------------------------------------------------------------------------------------------------------
select identity(int,1,1) as ID,* into #T2 from T2
select identity(int,1,1) as ID,* into #T3 from T3insert into T1(学号,姓名,机号)
select
a.学号,a.姓名,b.机号1
from
#T3 a,#T2 b
where
a.ID=b.ID