I would suggest, when you do the alias. use a very short suffix to the field name. a max of 2 or 3 character codes to specify which table is it coming from. with this, as a developer you can also find the field easily and will also not hamper the table relation.