Oracle Outer join Operator(+) with operand of OR or IN [message #659569] |
Mon, 23 January 2017 00:19 |
|
azamkhan
Messages: 557 Registered: August 2005
|
Senior Member |
|
|
Hello,
I want to use outer join operator and Or operand. My query is as follows:
Select *
From
a,
b,
c,
d, --|__> Both are same tables. But need different values.
f --|
Where a.a = b.a
And a.c = a.c
And ( (d.e = 'Value' And SubStr(d.g(+), 5, 10) = a.a)
Or
(f.e= 'Value' And SubStr(f.g(+), 1, 7) = a.c)
);
In the query table "D" and "F" represent same table, but to get different values I have to take them as separate tables.
I know that Oracle does n't allow to use "OR" operand with Outer Join (+). So I was wondering if there is any other alternate logic to do this.
|
|
|
|