Translate syntax join from oracle 8i to new syntax

0

Hi, could you help me with the translation of this query? apparently a join is made to the same table but I'm not sure.

select a.id_proc 
from Tabla1 a, Tabla1 b
where a.id_status = 0 
and a.id_proc = b.id_proc(+)
and b.id_status(+) = -1
and b.id_status is not null;
    
asked by Jesús 15.02.2018 в 18:13
source

0 answers