Outer Join not working in Oracle 8.1.7 1

[ModelTrains]

I am trying to join two tables where 4 records exist in one table, but not in the second table. I have done many outer joins in my life in other databases, but I am new to Oracle. Here is an example of the situation:

The EVENT_MAIN table has 4 records:

SELECT E.EVENT_KEY FROM EVENT_MAIN E
WHERE E.EVENT_KEY IN (100000046,100000047,100000048,100000049)

EVENT_KEY
----------
100000046
100000047
100000048
100000049

The SQL I want to work is:

SELECT E.EVENT_KEY, EF.CODE_KEY, EF.FACILITY_KEY
FROM EVENT_MAIN E, EVENT_FACILITY EF
WHERE EF.EVENT_KEY = E.EVENT_KEY(+)
AND EF.CODE_KEY=3
AND E.EVENT_KEY IN (100000046,100000047,100000048,100000049)

EVENT_KEY CODE_KEY FACILITY_KEY
---------- ---------- ------------
100000048 3 100001428
100000049 3 100000613

The desired result is:

EVENT_KEY CODE_KEY FACILITY_KEY
---------- ---------- ------------
100000046
100000047
100000048 3 100001428
100000049 3 100000613

What am I doing wrong?

 

[jee]

The (+) is on the wrong side:

SELECT E.EVENT_KEY, EF.CODE_KEY, EF.FACILITY_KEY
FROM EVENT_MAIN E, EVENT_FACILITY EF
WHERE EF.EVENT_KEY(+) = E.EVENT_KEY
AND EF.CODE_KEY (+)=3
AND E.EVENT_KEY IN (100000046,100000047,100000048,100000049)

 

[ModelTrains]

THANK YOU, JEE! Actually, this was a sub-select within a much larger SQL statement, but it works great!