Re: ORA-01417: a table may be outer joined to at most one other table

From: TurkBear <john.greco_at_dot.state.mn.us>
Date: Wed, 27 Aug 2003 11:06:33 -0500
Message-ID: <gllpkvo85r2mt85j6f3ctrd2hru94k3gnm@4ax.com>

"Christoph Seidel" <christoph.seidel1_at_gmx.de> wrote:

>Hi,
>
>could someone plz explain why this restriction exists. I can workaround it
>by creating a view with the first outer join and then outer join with this
>view. Shouldn't this be the same like doing it all in one statement? It
>seems that my workaround produces the right results. Are there any very bad
>performance impacts when using this workaround?
>
>My data:
>
>table A and B: about 100 rows
>table C: about 10 million rows
>
>outer joins:
>
>A = B(+)
>and
>C = B(+)
>

Don't know why, but your workaround is what Oracle says to do:

---

ORA-01417 a table may be outer joined to at most one other table

Cause: a.b (+) = b.b and a.c (+) = c.c is not allowed.

Action: Check that this is really what you want, then join b and c first in a view.

---

Received on Wed Aug 27 2003 - 11:06:33 CDT