left outer join to multiple tables

[mdl2]

I am getting ORA-01417: a table may be outer joined to at most one other table


AND CA.CASE_ID = CEYS.CASE_ID (+)
AND RPT.HRE_REPORTS_ID = CEYS.HRE_REPORTS_ID (+)
AND CA.CASE_ID = ICS.CASE_ID (+)
AND RPT.HRE_REPORTS_ID = ICS.HRE_REPORTS_ID (+)

What I am attempting to do is
I have a ca record which is an individual person. I want to get people that have had payments in the previous effective month of my selected report which is in the RPT table. If they have a CEYS record for the report period I want them or if they only have a ICS record for the report period I want them
for multiple programs (CEYS ICS) which has the effective date and the ca and I am trying to join them into 1 record
with a case statement
CASE ICS & CEYS
ICS only
CEYS only
END

Any suggestions?

 

[Dagon]

You can sometimes get round these sort of problems by joining two of the tables in an inline view and then joining that back to the third table.

 

[harebrain]

You could UNION (ANY or ALL, take your pick) two SELECTs, the first querying ICS, the second CEYS.