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

Daniel Morgan wrote:
>> My data:
>>
>> table A and B: about 100 rows
>> table C: about 10 million rows
>>
>> outer joins:
>>
>> A = B(+)
>> and
>> C = B(+)
>
> The restriction exists as you have coded it but it does not exist if
> coded correctly.
>
> SELECT *
> FROM a, b,
> (SELECT *
> FROM b, c
> WHERE c.col1 = b.col1(+)) x
> WHERE a.col1 = b.col1 (+)
> AND a.col1 = x.col1;

Hm, and what about the performance of that beast? Received on Wed Aug 27 2003 - 15:04:28 CDT