Re: HELP! Oracle Won't Let Me Outer Join...

>contrapositive wrote:
>
>> Hi. I have a query that looks something like this...
>>
>> SELECT ...
>> FROM
>> ORDER_HEADERS h,
>> ORDER_DETAILS d,
>> ...,
>> INVOICES i
>> WHERE ...
>> AND
>> decode(sign(d.TOTAL_PRICE), -1, 'C', 'D') --'C'redit/'D'ebit
>> ||
>> h.ORDER_NUMBER
>> = i.INVOICE_NUMBER(+)
>>
>> So I need to outer join on INVOICES, but I get the "table may be outer
>> joined to only one other table" error. I didn't realize this error
>> also applies to concatenation.

I ran into a problem similar to this, turned out the solution was to put (+) after both of the pieces being concatenated.

John

--
Got an Oracle database question?
Try the search engine for the database docs at:
http://tahiti.oracle.com/