Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> HELP! Oracle Won't Let Me Outer Join...
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.
This is a legacy database, so I can't manipulate the table definitions or anything. Is there some creative way to work through this?
Thanks in advance...
-jk Received on Mon Apr 08 2002 - 08:14:23 CDT