Mark and Paul,

Here comes the other position. I follow the relational design principle that if two fields in two tables share the same domain they should have the same name, so the field name is City for the city field in every table ( or maybe cCity but I don't do this regularly because it is so easy to get the data type in code).

I don't worry about aliasing in SQL because I would alias even if I didn't have to to make the SQL self documenting for me in 6 months when I don't remember which table has the prefix fgc_.