求一条合并记录的sql语句

[gd4134]

例：
table1
A B
1 a
2 b
3 c
4 d
5 e

table2
C D
6 f
7 g
8 h
9 i
10 j

结果
A B C D
1 a 6 f
2 b 7 g
3 c 8 h
4 d 9 i
5 e 10 j

[dulei115]

select a.*, b.*
from table1 a join table2 b on a.a = b.c - 5

????

[liangpei2008]

select t1.a,t1.b,t2.c,t2.d
from table1 t1,table2 t2

[itblog]

select * from table1 t1 inner join table2 t2 on t1.A+5=t2.C

[wwh999]

好像是笛卡爾...
select a.*,b.* from a,b

[xeqtr1982]

declare @t table(a int,b varchar(10))
insert into @t select 1,'a'
union all select 2,'b'
union all select 3,'c'
union all select 4,'d'
union all select 5,'e'

declare @a table(c int,d varchar(10))
insert into @a select 6,'f'
union all select 7,'g'
union all select 8,'h'
union all select 9,'i'
union all select 10,'j'

select [id]=identity(int,1,1),* into # from @t
select [id]=identity(int,1,1),* into #1 from @a

select a.a,a.b,b.c,b.d from # a,#1 b where a.id=b.id

drop table #,#1

[liangpei2008]

对不起，看错了