有3个sql语句
1,select id from A where aa='aa'
2,select sex from B where bb='bb'
3,select name from C where cc='cc'A,B,C3个表满足条件的分别有2,5,3条数据,现在想用一条sql来实现(A,B,C之间没有联系)期待结果:
id sex name
01 1 jack
02 0 tom
0 jone
1
1怎么做,请指教!
1,select id from A where aa='aa'
2,select sex from B where bb='bb'
3,select name from C where cc='cc'A,B,C3个表满足条件的分别有2,5,3条数据,现在想用一条sql来实现(A,B,C之间没有联系)期待结果:
id sex name
01 1 jack
02 0 tom
0 jone
1
1怎么做,请指教!
解决方案 »
- oracle报错ORA-01000: maximum open cursors exceeded
- sys用户下的表如何导入到access中
- select 两个表 格式化 select
- 请教:如何可以把SQL*PLUS输入的命令用C编程来实现(如sqlplus命令shutdown immediate如何用C来实现)
- 为什么我的对象里的VARCHAR2字段中文串不能正常显示
- 如何不安装ORACLE客户端,正常使用PL/SQL?
- 如何查看系统拥有哪些DBMS包?如何为系统增加或删除DBMS包?
- 求Orcale数据类型转换函数!
- 终于装好了oracle 8.1.6 for windows
- ORA-12541,tns,没有监听器。。。这个是什么错误啊???急急急!!!
- 问一个简单的问题,在线等
- 初学oracle,请问需要怎样得软硬件环境?
(Select rownum rn,id from A where aa='aa' order by id) t1
full outer join
(Select rownum rn,sex from B where bb='bb' order by sex) t2
on t1.rn=t2.rn
full outer join
(Select rownum rn,name from C where cc='cc' order by name) t3
on t2.rn=t3.rn
order by t1.rn,t2.rn,t3.rn
(
SELECT ROWNUM RN,T1.ID,T2.SEX FROM
(SELECT ROWNUM RN,ID FROM A WHERE AA='AA' ORDER BY ID) T1
FULL OUTER JOIN
(SELECT ROWNUM RN,SEX FROM B WHERE BB='BB' ORDER BY SEX) T2
ON T1.RN=T2.RN
ORDER BY T1.RN,T2.RN
) T11
FULL OUTER JOIN
(SELECT ROWNUM RN,NAME FROM C WHERE CC='CC' ORDER BY NAME) T3
ON T11.RN=T3.RN
ORDER BY T11.RN,T3.RN