Hi,

Thanks DaPi.
I have tried to run it and it runs.But as my tables are empty I could not try (for sure) that it gave the right result.
As for the (+) thing I know it goes on that side.
But as I am bringing some sp from t-sql to oracle I have the queries
in t-sql and in T-sql u can do much like joining groups in different ways and I don't know if that make any difference in oracle.

e.g

select *
from t1 inner join t2
inner join t3 on t2.id3=t3.id3
on t1.id1=t3.id1
left outer join t4
inner join t5 on t4.id4=t5.id4
on t2.id2=t4.id2 and t3.id3=t5.id3;


in this case as in the previos it joins groups of joins and is very well specified.
So I can not escape from outer joins.Or I can??

thanks again
edli