-
Multiple Outer joins on same table
Hi all, i have a question on Outer join. Is that possible to make a multiple outer joins on one table?
Here is my test case:
I have multiple join condition in my query. I am using 6 tables and 5 join conditions.
Table A a,
Table B b,
Table C c,
Table D d,
Table E e,
Table F f
Where a.id = b.id (+) and
b.id = c.id (+) and
a.id = d.id (+) and
d.id = e.id and
a.id = f.id (+)
When I am doing this I got an error like single table defined multiple outer joins.
Can some one help me on this?
I can do this in other way like writing In-line views but i want to know is this possible or not. I am Using ORACLE 10g.
Thanks a lot for replying
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|