> >
> >
> > 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
Agreed.
We don't use single character varible names so why would we use single character alias names?
Ken
You shall know the truth - and the truth shall set you free. (John 8:33)