简单问题,急,解决给分.

[yeeyee]

t1

aa bb cc
1 2 3
2 2 4

t2

aaa
1
3

t3

aa bb cc aaa
1 2 3 1
2 2 4 3

表没关联字段.

[caixia615]

select a.*,aaa=(select aaa from t2) from t1

[caixia615]

select a.*,aaa=(select aaa from t2) from t1 a

[marco08]

--try

select
aa=(select aa from t1),
bb=(select bb from t1),
cc=(select cc from t1),
aaa=(select aaa from t2)

[akuzou]

select id=identity(int,1,1),* into #t1 from t1 order by aa
select id=identity(int,1,1),* into #t2 from t2 order by aaa
select a.aa,a.bb,a.cc,b.aaa from #t1 a,#t2 b where a.id=b.id

[gc_ding]

select * from t1,t2

[yczealot]

在t1,t2中都加入一个标识列,用标识列进行关联即可,前提是两表记录条数相等

[baggio328]

select
aa=(select aa from t1),
bb=(select bb from t1),
cc=(select cc from t1),
aaa=(select aaa from t2)

[baggio328]

我晕，慢了这么多

[xiequanqin]

那就给他+一个关联列

可以分别都SELECT INTO 临时表（加个Identi字段），再根据这个JOIN

[caixia615]

declare @a table(aa int,bb int,cc int)
insert into @a select 1,2,3 union all
select 2,2,4
declare @b table(aaa int)
insert into @b select 1 union all
select 3
select id1=identity(int,1,1),a.* into #a from @a a
select id2=identity(int,1,1),b.* into #b from @b b
select a.aa,a.bb,a.cc,b.aaa from #a a,#b b where a.id1=b.id2
drop table #a,#b
result:
aa bb cc aaa
----------- ----------- ----------- -----------
1 2 3 1
2 2 4 3

（所影响的行数为 2 行）

[fish_yht]

ls的方法可行
--------------------------
select identity(1,1) id,* into #aa from t1
select identity(1,1) id,* into #aaa from t2

select aa,bb,cc,aaa from #aa a inner join #aaa b on a.id = b.id

[yeeyee]

我帮我同学问的,解决了,谢谢了.