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;