• Why use the cross join?

    SELECT *

    FROM PersonRecord A

    INNER JOIN PersonRecord B

    ON A.PersonID = B.PersonID

    AND A.VersionID = B.VersionID - 1

    WHERE B.DEDate > A.DEDate