This is the A,B,C table problem, right? Cant join ..
select * from a,b,c
where
a.c = b.c(+) and
c.c = b.c(+)
... so you have to hide one of the joins inside an inline view ...
select * from a,(select * from b,c where b.c(+) = c.c) d
where d.c(+) = a.(+)
or somethin like that.




Reply With Quote