In the event of a tie, more data beyond the last history of that tie, as laid out in the ORDER BY clause, will be included in The end result set.What I believe helps make my TOP approach so lousy is that the rows becoming picked from t1 and t2 are a number of the newest rows (greatest values for t1.id and t2.id). The question optimiser has assumed