Jay,

But that is not always feasible. There are lots of times were code needs to work against different tables and hardcoding a table/alias would prevent it from being able to do that.

>I forgot to mention one thing. Another convention that he believes would resolve any conflicts between non-notated variables and field names is simply by adding the table alias to all field references. This sounds reasonable, but again I haven't found any good discussion on this point.