How do I Left out join 2 tables to a single table

[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?

 

[PHV]

Any suggestions?
Yes: post in an oracle forum.

 

[r937]

suggestion: please try your question in the oracle forums

this is the ANSI SQL forum, and ANSI does not recognize that plus sign syntax

r937.com | rudy.ca