Comparar datos de una misma tabla

[esteban0291]

lo resolvi con esto


SELECT T1.Confirmed,T1.UserSign2,t1.LogInstanc,t3.userSig n2, T1.*
FROM adoc AS T1
LEFT JOIN adoc AS T2 ON T2.docentry=T1.docentry AND T2.LogInstanc=T1.LogInstanc-1
left join ousr as t3 on t1.UserSign2=t3.USERID
WHERE T1.Confirmed='Y'
AND (T1.LogInstanc=0 OR T2.Confirmed='N' AND T1.ObjType=17)


saludos,