SELECT Parent.Numero,ParentVersion.Title FROM Parent
INNER JOIN Child ON Parent.Numero=Child.NoParent 
WHERE Child.Numero = 
 (SELECT TOP 1 Numero FROM Child Child2
 WHERE Child2.NoParent=Parent.Numero
 ORDER BY Child2.ModDate DESC)