Have you tried using the new ANSI SQL syntax introducted in 9i. It is
something like SELECT .... FROM table_a OUTER JOIN table_b ON ...
(Sorry, please check the exact syntax).
puneetbans_at_gmail.com wrote:
> I am using Oracle 9i. I have a join condition where the left side of
> the join is a correlated sub query and I want to outer join it to
> another table. However, Oracle does not allow the use of (+) operator
> with sub queries. A common solution suggested to this problem is to use
> in-line views. This solution works only if the sub query is not a
> correlated sub query as the in-line query gets executed first. Does
> anybody have any idea how to make the outer join work with a correlated
> sub query?
Received on Thu Sep 28 2006 - 05:43:56 CDT
