While in the party of the tie, further documents over and above the final document of that tie, as specified in the Purchase BY clause, will likely be A part of the result set.What I feel tends to make my Top rated approach so bad would be that the rows getting picked from t1 and t2 are several of the newest rows (biggest values for t1.id and t2.id