not in、outer joins与not exists
上一篇 /
下一篇 2010-06-22 17:43:50
/ 个人分类:ORACLE
51Testing软件测试网4t*Q%I9RP_i qNOT IN:
Lr8@5QW1Y0select *51Testing软件测试网WH@%`| G#[5S+c6kQ
from rateparam1.Work_Order_Def a
o I"?2Y.Q_L0 where workorder_id not in
EO2T-H C`T)b0 (select b.workorder_id from rateparam1.work_order_process_log b);
uV't/l}-`9L051Testing软件测试网(cv2E(G"iM uM/^OUTER JOINS: 51Testing软件测试网
N9~loo%mh(j@'V
select * from rateparam1.Work_Order_Def a,rateparam1.work_order_process_log b
a8z Qi
Oa0where a.workorder_id = b.workorder_id(+)51Testing软件测试网.t'O
u6`.glr]
and b.workorder_id is null;51Testing软件测试网6f)IE
{6sR
E
b7?5q.]an0U9m0NOT EXISTS:51Testing软件测试网"I(o!wL1Gs(fuh P
select *51Testing软件测试网6Ir{
Fd1|)h7\&p
from rateparam1.Work_Order_Def a
#G9P+bN1L&K!j0 where not exists (select *51Testing软件测试网XJR b+t3p2`
from rateparam1.work_order_process_log b51Testing软件测试网"S4i5^(Q0jVQF&pe
where a.workorder_id = b.workorder_id)51Testing软件测试网3rg#O6r X5X
ew-M+a_ `u&X.v051Testing软件测试网/r%g!ZZ5Re_{n2x
A表大于B表,查找A>B的部分(A中存在,B中不存在)。51Testing软件测试网;|s }5BC
select * from A