I have been struggling with the following query for the longest time
and have finally given up. I'm trying to port this query from an
MS-Access environment to Oracle 8i. I'd like to use the legacy join
syntax that Oracle 8i accepts i.e. the (+) for outer joins. I know
that there are some restrictions as far as outer joins are concerned
i.e. one has to use views if multiple outer joins need to be
performed.
--
SELECT
<columns>
FROM
((tbl_Contract
LEFT JOIN BAGRPT_SUBSCRIBER_INFO ON
tbl_Contract.BAN = BAGRPT_SUBSCRIBER_INFO.BAN
)
LEFT JOIN BAGRPT_RENEWAL_PP ON
(tbl_Contract.BAN = BAGRPT_RENEWAL_PP.BAN) AND
(tbl_Contract.strNewCTN = BAGRPT_RENEWAL_PP.SUBSCRIBER_NO)
)
LEFT JOIN BAGRPT_REF_RATE_PLAN ON
tbl_Contract.strRateName = BAGRPT_REF_RATE_PLAN.SOC;
--
Thanks in advance for your help.
Viraf
_____________________________________________________________________________
Received on Fri Dec 19 2003 - 18:25:11 CST
