也就是:Q3.character1,Q3.character3 的值代不出來!!!
請大家幫看一下!
謝謝
請大家幫看一下!
謝謝
解决方案 »
- 为什么在oracle developer中执行select激活commit按钮?
- 请教如何删除与主键无关联的外键?
- 谁能让找个Oracle数据库服务器彻底瘫痪?
- long类型的列存放的是Time,如何直接在SQL中显示Time?
- 学习Oracle,达人推荐下有啥经典书?
- ORACLE 高手进来练习一下SQL语句。
- oracle进程不断增加,耗尽系统资源!急等高手解决!
- 分组排序查询语句如何写?
- Oralce 安装后出现这样的提示!!高手请看!
- Oracle卸不掉啊?救命
- 我有一个表示状态的字段用“1,2,3”表示,在返回的结果中把它变为“有,无,不确定”!
- oracle的乱码问题哪位大虾能帮帮忙???谢谢!!!
from (select collection_id,character1 ,character3 from qa_results where CHARACTER3='拒絕' and RECEIPT_NUM = '304110034') q1,
(select collection_id,character1 from qa_results where (CHARACTER3 is null or CHARACTER3='') and RECEIPT_NUM = '304110034') q2,
(select collection_id,character1 ,character3 from qa_results where CHARACTER3 not in ('拒絕','接受','',null and RECEIPT_NUM = '304110034') q3
where q1.collection_id=q2.collection_id(+) and q1.collection_id=q3.collection_id(+)
这个结果集中条件应该是
where (... or ...) and ...而原来那句写成了 where ... or ... and ...
from (select collection_id,character1 ,character3 from qa_results where CHARACTER3='拒絕' and RECEIPT_NUM = '304110034') q1,
(select collection_id,character1 from qa_results where (CHARACTER3 is null or CHARACTER3='') and RECEIPT_NUM = '304110034') q2,
(select collection_id,character1 ,character3 from qa_results where CHARACTER3 not in ('拒絕','接受','',null) and RECEIPT_NUM = '304110034') q3
where q1.collection_id=q2.collection_id(+) and q1.collection_id=q3.collection_id(+)這樣後一Q2.character1,Q3.character1,Q3.character3 的值都沒有了???
from (select collection_id,character1 ,character3 from qa_results where CHARACTER3='拒絕' and RECEIPT_NUM = '304110034') q1,
(select collection_id,character1 from qa_results where (CHARACTER3 is null or CHARACTER3='') and RECEIPT_NUM = '304110034') q2,
(select collection_id,character1 ,character3 from qa_results where (character3 !='拒絕' and length(character3)>0 and character3 !='接受') and RECEIPT_NUM = '304110034') q3
where q1.collection_id=q2.collection_id(+) and q1.collection_id=q3.collection_id(+)
union select collection_id,character1 ,character3,null,null,null from qa_results where CHARACTER3='接受';
from (select collection_id,character1 ,character3 from qa_results where CHARACTER3='拒絕' and RECEIPT_NUM = '304110034') q1,
(select collection_id,character1 from qa_results where (CHARACTER3 is null or CHARACTER3='') and RECEIPT_NUM = '304110034') q2,
(select collection_id,character1 ,character3 from qa_results where (character3 !='拒絕' and length(character3)>0 and character3 !='接受') and RECEIPT_NUM = '304110034') q3
where q1.collection_id=q2.collection_id(+) and q1.collection_id=q3.collection_id(+)
union select collection_id,character1 ,character3,null,null,null from qa_results where CHARACTER3='接受' and RECEIPT_NUM = '304110034';