You might try this although I'm not sure it's going to work, I have no place to test it :


SELECT i.nu_lega, no_alum, co_curso, fe_mov, i.co_control FROM inscrip i, dpalumno a WHERE co_mate= '950427' AND co_curso = 'R3061' AND i.nu_lega = a.nu_lega and fe_mov=(select max(fe_mov) from inscrip having co_mate= '950427' and co_curso = 'R3061' )