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