i always felt that if the ID column was in a Table called 'State', then its self explanatory that its the 'StateID'.

so it was unecessary to call the column 'StateID'.

It also makes it easier to see what is the Primary Key and what is the Foreign Key, in your query, where 'ID' is the Primary Key and [tablename]ID is the Foreign Key.

e.g

where t1.ID = t2.StateID

as opposed to:

where t1.StateID = t2.StateID