> >
> > Personally, I find it confusing.
> >
> > Regards
> > Tushar
>
>
> Hi Tushar,
> Consider manually creating a four-table join with 20 columns in the select list, one correlated subquery, a GROUP BY on two columns, a WHERE clause for 5 columns + an ORDER BY over three columns. The table names average 10 characters.
> Columns: 20 * 10
> Correlated subq: 2 * 10
> ON clauses: 6 * 10
> WHERE: 5 * 10
> GROUP BY: 2 * 10
> ORDER BY: 3 * 10
> Sum = 38*10=380 characters to type.
> Using one-letter table aliases. 38 characters to type , and to read.
> If these are upper case and the column references lower case, they stand out well in the text, for maximum readability.
>
> If you submitted such a query with full table name repeated 38 times for publication in a magazine or book, I'm sure the knowledgable editor would demand a rewrite.
>
> -Anders

Would he? The editor should be thinking of the poor reader and not the poor typist. Reading all these and having to coordinate the single character alias with the actual tablename would not be easy on the reader.

Regards
Tushar