> >
> >
> > The aliases A, B and C are no mystery, are they?; One can just look at the FROM clause. 'View SQL' in the Query/View Designer, or DBGetProp('viewname,'VIEW','SQL')
> >
> >

FROM Table1 AS T1  
> >  JOIN Table2 AS T2 ON T1.key=T3.key 
> >  JOIN Table3 AS T3 ON .. 

> >
> > Technically, there's no problem with using single-letter query aliases in VFP but the letters A to J should be avoided (and don't work in VFP's Query/View Designer).
> >
> > In the case of self-joins you just have to employ table aliases
> > FROM Customers AS C1 JOIN Customers AS C2 ON C1.col1 >= C2.col2
> >
> >
> >
> > Cheers
> > Anders
>
> Personally, I find it confusing.
>
> Regards
> Tushar

I do too. I much prefer Customers to C or C1. With cut and paste it is no faster to enter "Customers." or "c.". I've got some huge queries and it's never bothered me to see "Customers". I'm flexible about style - more so than some of the people I've talked to.


Mike Yearwood