Hi Guys
I appreciate if someone help me out, I have the following query and its is working fine.
Query
select * from
journals,cs, inf, cf, ali, pmc, tt, fc, td
where cs.information_id = inf.information_id and
journals.case_id = cs.case_id AND
inf.COURT_FILE_ID = cf.COURT_FILE_ID AND
cs.PERSON_ID = ALI.PERSON_ID(+) AND
cs.alias_seq = ali.alias_seq(+) and
journals.payment_method_cd = pmc.code
and journals.trans_type_cd=tt.code
AND fc.case_id=journals.case_id
AND fc.trans_type_cd= journals.trans_type_cd
AND fc.financial_control_id=td.financial_control_id(+)
AND tt.rest_indr='Y'
AND journals.journal_type_cd NOT IN ('D','DRV')
;
but when I add the following condition then I'm getting error.
Condition
and journals.victim_id=td.victim_id(+)
Error
ORA-01417: a table may be outer joined to at most one other table
01417. 00000 - "a table may be outer joined to at most one other table"
*Cause: a.b = b.b and a.c = c.c is not allowed
*Action: Check that this is really what you want, then join b and c first
IN A VIEW.
Error at Line: 14 Column: 28
I know the reason of error but my question is that is there any way to add this joining condition...
It is very difficult to add sample data in all mentioned table so if somebody guide me without sample data then I really appreciate it. Thanks