>>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#
1154483It'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