> >
> > Personally I find Customers.Col1 easier to read then C.Col1
> >
> > Regards
> > Tushar
>
>
> I agree for such a small example. But it becomes a very different reading - and writing - experience when there are twentyfive columns from six tables, their JOIN conditions and a slew of WHERE conditions and ORDER BY columns are added and 15-byte long table names are repeated fifty times in the query. That is also the way a query utility writes it by default ,but please consider the plight of the poor bastard who has to write all of it by hand, and spell it right every F time.
> No siree, not on my watch.
>
> -Anders

I go for the query utility, otherwise 6 months down the road, you have to keep wondering what the alias a,b,c mean specially for the 25 column 6 table joins.

Regards
Tushar