Michael,
It handles aliases very well, except that I personally think it makes the sql much harder to read.
You are running into an issue because of the Xbase roots of the language. The first ten workareas can be accessed using the aliases A .. J:
close all
use TheTable
? TheTable.Field
? a.Field
you see the same value printed in both cases.
If you want to use single character aliases in your SQL then you need to use letters K, L, N-Z. M is reserved for memory variables. All in all you are better off not using single character aliases.
>Thanks, all the suggestions seemed to help work. Why doens't VFP handles aliases well?