数据库表
select * from test_01;
ID NAME TYPE NAME2
1 NA1 A 1
1 NA11 B 11
1 NA111 C 11
2 NA2 A 2
2 NA22 B 22
2 NA222 C 222
select t4.id ,t1.name,t1.name2 , t2.name,t2.name2,t3.name,t3.name2
from (select id, name,name2 from test_01 where type='A') t1,
(select id , name,name2 from test_01 where type ='B') t2,
(select id , name,name2 from test_01 where type ='C') t3,
(select id from test_01 group by id ) t4
where t4.id = t1.id(+) and t4.id = t2.id(+) and t4.id = t3.id(+)
结果:
ID NAME NAME2 NAME NAME2 NAME NAME2
1 NA1 1 NA11 11 NA111 11
2 NA2 2 NA22 22 NA222 222
参考:http://loveexception.javaeye.com/blog/126858
希望有更好方法的网友回复、指正。
select * from test_01;
ID NAME TYPE NAME2
1 NA1 A 1
1 NA11 B 11
1 NA111 C 11
2 NA2 A 2
2 NA22 B 22
2 NA222 C 222
select t4.id ,t1.name,t1.name2 , t2.name,t2.name2,t3.name,t3.name2
from (select id, name,name2 from test_01 where type='A') t1,
(select id , name,name2 from test_01 where type ='B') t2,
(select id , name,name2 from test_01 where type ='C') t3,
(select id from test_01 group by id ) t4
where t4.id = t1.id(+) and t4.id = t2.id(+) and t4.id = t3.id(+)
结果:
ID NAME NAME2 NAME NAME2 NAME NAME2
1 NA1 1 NA11 11 NA111 11
2 NA2 2 NA22 22 NA222 222
参考:http://loveexception.javaeye.com/blog/126858
希望有更好方法的网友回复、指正。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/118838/viewspace-592224/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/118838/viewspace-592224/