>Keep the aliases for the columns otherwise it will be hard to maintain without knowing structures of your tables.

thanks, I normally do that, but anyway my naming convention helps with identifying which tables fields come from.