This content has been marked as final. Show 6 replies
This question is NOT urgent X-(
I think this is nice decode usage on oracle8.1.6 :-)
with a as( select 5 JoinKey1,10 JoinKey2 from dual union select 15 JoinKey1,20 JoinKey2 from dual union select 15 JoinKey1,30 JoinKey2 from dual), b as ( select 5 JoinKey,'aaa' name from dual union select 10 JoinKey,'bbb' name from dual union select 30 JoinKey,'ccc' name from dual) select a.JoinKey1,a.JoinKey2,name from a,b where 1 = decode(b.JoinKey(+),a.JoinKey1,1,a.JoinKey2,1); JOINKEY1 JOINKEY2 name -------- --------- ---- 5 10 aaa 5 10 bbb 15 20 null 15 30 ccc
Well, it's certainly not urgent now.
I don't think that Jane realises that Guest is people who are no longer members and don't give a flying monkeys about getting a response now.
Dragging up all these old threads is becoming annoying Jane. Stop it. You are causing disruption of the forums.
SQLCookbook mentions "Outer Join" with "or logic" on Oracle 8.1.7
However I think that below one is simple method.
where 1 = decode(b.JoinKey(+),a.JoinKey1,1,a.JoinKey2,1)
Well, it's certainly not urgent now.LoL :-)