Hi All,
I have below three tables with the values .The below mentioned outer join query not working and its behave like inner query.
CREATE TABLE RET_FUND_FEE
(
NPTF VARCHAR2(8 CHAR),
TPART VARCHAR2(4 CHAR)
);
CREATE TABLE PART_PTF
(
Mf_Id VARCHAR2(6 CHAR) NOT NULL,
TPARTS VARCHAR2(4 CHAR) NOT NULL
);
CREATE TABLE TFC_FUNDS
(
NPTF VARCHAR2(8 CHAR) NOT NULL,
MULTIFONDS_ID VARCHAR2(6 CHAR)
);
INSERT INTO RET_FUND_FEE VALUES('111','A');
INSERT INTO RET_FUND_FEE VALUES('111','D');
INSERT INTO RET_FUND_FEE VALUES('111','E');
INSERT INTO PART_PTF VALUES('MF1','A');
INSERT INTO PART_PTF VALUES('MF1','B');
INSERT INTO PART_PTF VALUES('MF1','C');
INSERT INTO TFC_FUNDS VALUES('111','MF1');
INSERT INTO TFC_FUNDS VALUES('111','MF1');
INSERT INTO TFC_FUNDS VALUES('111','MF1');
SELECT A.TPART, B.TPARTS,A.NPTF ,B.Mf_Id ,C.MULTIFONDS_ID, C.NPTF
FROM RET_FUND_FEE A, PART_PTF B, TFC_FUNDS C
WHERE A.NPTF = C.NPTF
AND C.MULTIFONDS_ID = B.Mf_Id
AND A.TPART = B.TPARTS ( + )
AND C.MULTIFONDS_ID = 'MF1'
AND C.NPTF= '111'
Here I am expecting all the records from RET_FUND_FEE table as I am using outer join.
But I am getting only matching records from RET_FUND_FEE , PART_PTF as a Inner join.Can anyone please let me know what is missing.
My oracle version is 11g