高分求一个语句！

[cmt123]

table1 表
Column
1
2
3
4
5
6
7
8
.
.
.

table2 表
J_Receipt J_Goods J_Name
s0000s 0101001 ss
s0000q 0101002

求一个SQL语句，生成一个表table3,如下
Column J_Receipt J_Goods J_Name
1 s00000s 01 ss
2 s00000q 02 bb
3
4
5
6
7
8
.
.
.

table1与table2没有关联！

[jeck_zhou]

up

[CrazyFor]

table1 表
Column
1


table2 表
J_Receipt J_Goods J_Name
select identity(int,1,1) column,* into #temp from table2
select * from table1 a left join #temp b on a.column=b.column

[longji]

select identity(int,1,1) as Column,J_Receipt,right(J_Goods,2) as J_Goods,J_Name
from table2
是不是需要这种效果！

[cjt000000]

up

[happydreamer]

alter table2 add id int identity(1,1)

select Column, J_Receipt , right(J_Goods ,2), J_Name
from table2

alter table2 drop column id

[pengdali]

select identity(int,1,1) column,* into #temp from table2
select * from table1 a left join #temp b on a.column=b.column
drop table #temp

[longji]

select identity(int,1,1) as Column,J_Receipt,right(J_Goods,2) as J_Goods,J_Name
into #lfy from table2
select * from #lfy

[pengdali]

select identity(int,1,1) column,* into #temp from table2
select * from table1 a left join #temp b on a.column=b.column
drop table #temp

[pengdali]

select identity(int,1,1) column,* into #temp from table2
select * from table1 a left join #temp b on a.column=b.column
drop table #temp

[joygxd]

select identity(int,1,1) column,* into #temp from table2

select * from #temp

drop table #temp

[Robin]

呵呵！
题意不清！

[愉快的登山者]

select *, indentity(int,1,1) id into #t from table2
go
select A.Column, B.J_Receipt, B.J_Goods, B.J_Name from table1 A
left jion #t B on A.Column = B.id