| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.misc -> Help getting around Outer Join limitation
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
![]() |
![]() |