>Thanks, I was able to find something:
>
>

>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)
>

Yes, that was one of the solutions I listed (Message ID: 1478675) - not the most performant as I know.