Hi,

I have this in t-sql:

table at1(id1,name)
at2(id2,name,id1,id4)
at3(id3,name,id_t)
at4(id4,name,id_t,id5)
at5(id5,name)


I have this join

select *
from at1 right outer join at2 on at1.id1=at2.id2
right outer join
(at3 inner join at4 on at4.id_t=at3.id_t
inner join at5 on at5.id5=at4.id5) on at2.id4=at4.id4


how is this done in Oracle?
Is this right???

select *
from at1,at2,at3,at4,at5
where at2.id1=at1.id1(+)
and at3.id_t=at4.id_t
and at5.id5=at4.id5
and at4.aid4=t2.id2(+)

Thanks