[ausp]

The aliases don't force you to follow each one through; eyes can do no jumping if you like in either case.

But if you can't infer from the column name which table they will come from, I find having the option to check far more preferable to that of having no way of knowing.

[rbanffy]

I think the aliases in the example are very intuitive - it's easy to correctly guess where they come from.