Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> HELP! Oracle Won't Let Me Outer Join...

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

From: contrapositive <contrapositive_at_hotmail.com>
Date: 8 Apr 2002 06:14:23 -0700
Message-ID: <4e07f6b1.0204080514.718a8d3a@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US