>>>>Is that correct? I thought that SQL aliases have nothing to do with A-J aliases for work areas.
>>>>
>>>>>It's a bad idea to use one leter meaningless table aliases in a query. It makes the query totally unreadable. It also could be dangerous because letters A-J are reserved for workareas 1-10.
>>>
>>>From my testing, you are correct: Message#
1154483>>
>>It's no longer a problem, but at one time, you could get unexpected results with something along these lines:
>>
>>
>>SELECT 1
>>USE MyTable
>>
>>SELECT ... ;
>> FROM AnotherTable A ;
>> ...
>>
>>
>>VFP would get confused over what A meant.
>>
>>Tamar
>
>What was that time?
>In my experience, (V)FP was NEVER confused in the scenario above. Maybe the programmer, but that's always a possibility.
My example may be too simple, but I definitely saw cases where the use of single letter aliases in queries caused a problem.
Tamar