Ver originalSELECT IDE, NUM, ind, finic, f_inist, f_baja FROM tabla INNER JOIN (SELECT IDE AS iden FROM tabla WHERE ind IN(0,8) GROUP BY IDE, f_inst HAVING COUNT(*) > 1)T1 ON T1.iden = tabla.IDE