Refactoring in MySQL

Suppose you have used SQL to obtain aggregated data, now to join it back with the originally granular data at the record level, you will have to reproduce entire bunch of SQL statements to get it out. You may think of using aliases, but at that point, the SQL is not smart enough to remember what that alias stands for, since the new data set comes after the Join statement. Alias is only effective up to just before the next join statement.
So is there anyway to simply recall ?