Thanks for the suggestion. ANSI syntax is the first thing I tried. ANSI
syntax forces me to put my join condition in the FROM clause instead of
the WHERE clause. In the FROM clause, the correlated sub query does not
work. If it was not a correlated subquery, this would have soved the
problem. I am still stuck.
Ashish wrote:
> 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 - 10:08:08 CDT
