Beyond the Alias

I was writing a fairly complex SQL query this morning (NOT the one above :)).