Originally Posted by
June7
Possibly. It can be confusing to see exactly same name multiple times in a query. Will mandate prefixing reference in query with source table/query name. Many prefer to have some distinction between names. You are free to do whatever makes sense to you. Just be consistent.
If you haven't heard already - do not use spaces nor punctuation/special characters (underscore is only exception) in names nor reserved words as names. I once encountered an issue with a field name that included a reserved word separated by space or underscore (can't remember which). Even enclosing in [] didn't help. Had to rename field.