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

Home -> Community -> Usenet -> c.d.o.misc -> Help getting around Outer Join limitation

Help getting around Outer Join limitation

From: Ben Geyer <Geyer_Ben_A_at_cat.com>
Date: 1998/02/02
Message-ID: <34D62E0E.7131508E@cat.com>#1/1

I have a query built in MS Access 97 which I need to convert to Oracle SQL for use in a web application. The problem is that this query needs two Outer Joins and Oracle only allows a single outer join per table in a query. Here's what I have so far: Notice the two outer joins here. If I remove one of these, this query will work.

SELECT ORDERCONTAINER.ORDERNUMBER,ORDERCONTAINER.CONTAINERCODE, ORDERS.ORDERGRPCD,ORDERS.ORDERNUMBER,SUPPLIER.SUPPLIERCODE, SUPPLIER.SUP_PLANTCODE,CONTAINER.CONTAINERCODE,CARRIER.CARRIERCD FROM ORDERCONTAINER,SUPPLIER,CONTAINER,ORDERS,CARRIER,(SELECT ORDERGRPCD FROM ORDERGRP
WHERE
(ORDERS.ORDERNUMBER = ORDERCONTAINER.ORDERNUMBER )

AND (ORDERS.SUP_PLANTCODE = SUPPLIER.SUP_PLANTCODE )
AND (ORDERS.SUPPLIERCODE = SUPPLIER.SUPPLIERCODE )
AND (CONTAINER.CONTAINERCODE=ORDERCONTAINER.CONTAINERCODE )
AND (ORDERS.CARRIERCD(+) = CARRIER.CARRIERCD )
AND (ORDERS.ORDERGRPCD(+)=ORDERGRP.ORDERGRPCD)
/

I would appreciate any help. Please reply to my email address as well as this newsgroup.

Thanks,
Ben Geyer
Caterpillar, Inc.
geyer_ben_a_at_cat.com

--
Received on Mon Feb 02 1998 - 00:00:00 CST

Original text of this message

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