<snip>

>It just doesn't make much sense that you'd give alternate aliases (X in one statement and Y in another) to the columns between the select statements. For non-trivial queries it would be much harder for another developer following behind you to understand/modify/debug/ the SQL code.

Well "I forgives you, because you don't know what you do"