求一sql语句的写法？

Question

select id= identity(int,1,1),*  into  #hhh1 from 表A
select id= identity(int,1,1),*  into  #hhh2 from 表B
select #hhh1.col1,#hhh1.col1 col2 into 表C from #hhh1,#hhh2 where #hhh1.id=#hhh2.id
drop table #hhh1
drop table #hhh2

Answer 1

select identity(int,1,1) id,col1 into #t1 from a
select identity(int,1,1) id,col1 into #t2 from b
select #t1.col1,#t2.col1 col2 from #t1 full join #t2 on #t1.id=#t2.id
drop table #t1,#t2

Answer 2

改一下：
select #hhh1.col1,#hhh2.col1 col2 into 表C from #hhh1,#hhh2 where #hhh1.id=#hhh2.id