In the function of the tie, added information outside of the last file of that tie, as laid out in the ORDER BY clause, is going to be A part of the result set. I’ve been down the rabbit hole of complex queries And big datasets a lot more instances than I'm able to count. Believe me, pr