>IMO, SQL fields should be aliased one way or another because there's no sane way to format or tidy them, and this only if it's a join.

Could you elaborate? I don't need to alias fields in a join...

One other (slight) advantage to using prefixes (that occurred to me as I read another thread) is that there's no danger of using a reserved word as a field name.