比如A表
DATA1,DATA2,DATA3,DATA4,DATA5
3 , 4 , 5 , 6 , 7
7 , 6 , 5 , 4 , 3B表 data , Adata
3 , 333
4 , 444
5 , 555
6 , 666
7 , 777
我现在希望用SQL语句输出
333 , 444 , 555 , 666 ,777
777 , 666 , 555 , 444 ,333求一条SQL语句,或者效率最高俄SQL语句组
DATA1,DATA2,DATA3,DATA4,DATA5
3 , 4 , 5 , 6 , 7
7 , 6 , 5 , 4 , 3B表 data , Adata
3 , 333
4 , 444
5 , 555
6 , 666
7 , 777
我现在希望用SQL语句输出
333 , 444 , 555 , 666 ,777
777 , 666 , 555 , 444 ,333求一条SQL语句,或者效率最高俄SQL语句组
select (select adata from b where b.data = a.data1),(select adata from b where b.data = a.data2),(select adata from b where b.data = a.data3),(select adata from b where b.data = a.data4),(select adata from b where b.data = a.data5) from A
insert into A values(3 , 4 , 5 , 6 , 7 )
insert into A values(7 , 6 , 5 , 4 , 3 )create table B(data int, Adata int)
insert into B values(3 , 333 )
insert into B values(4 , 444 )
insert into B values(5 , 555 )
insert into B values(6 , 666 )
insert into B values(7 , 777 )select (select adata from b where b.data = a.data1),(select adata from b where b.data = a.data2),(select adata from b where b.data = a.data3),(select adata from b where b.data = a.data4),(select adata from b where b.data = a.data5) from A
====
测试通过。