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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only