> >
> > Hey Anders
> >
> > I'm not an MVP, but would like to be!
> >
> > Single letter aliases are unfortunately very common. So many samples show it. I prefer to use them like abbreviations if I do use them. So rather than A, B, C for Customers, Sales, Invoices I'd use C, S, I at the very least. A, B and C require mental acrobatics to remember what each stands for.
> >
> > Mike Yearwood
> >
> >
> >
>
> The aliases should I think be mnemonics for the full table name: Customer C01, Orders O01, OrderLines OL01, or something along those lines.
> The table alias have priority over other possible references in VFP; If you do FROM Addresses AS A in a query, VFP will never confuse that with some table in workarea A.
>
> -Anders

In this we are in full agreement. :) But a mnemonic is a means of triggering the actual. So I vote for using the actual. I don't notice anything slower or harder about it and I have used both methods. :)

Mike Yearwood