I don't really think the aliases in the SELECT have anything to do with the work areas... this is pretty standard SQL and I have never had a problem doing this in either 2.6 or 6.

BOb


>It still there in VFP 6. I would say it's really bad example :)
>
>>Hi Sergey,
>>
>>Thanks for the suggestion. I got the format for the SELECT from the Help File examples page. Here is an example from Help:
>>
>>SELECT a.company, b.idate, b.itotal ;
>> FROM customer a, invoices b ;
>> WHERE a.cno = b.cno
>>
>>Thanks,
>>
>>TFISHER
>>
>>>Terry,
>>>
>>>The letters a-j are reserved words in foxpro and reference the work areas from 1 to 10. It confuses foxpro totally. I recomend to use table names not aliases in select.