Hi Masters,
I have two table and i joined using full outer join based on some condition. but i got error like
ORA-25156: old style outer join cannot be used with ANSI joins
25156. 00000 - "old style outer join cannot be used with ANSI joins"
I have given by query below
select JOIN_TAB.NAME_J,JOIN_TAB.ID_J,
JOIN_TAB1.NAME_J1,JOIN_TAB1.ID_J1
from
join_tab
full outer join
join_tab1
on JOIN_TAB.ID_J = JOIN_TAB1.ID_J1(+)
where JOIN_TAB.ID_J(+) = 1
;
is there any mistake on above query if so please guide me to solve that?
thanks in advanced