>>> And I didn't know recno() function works with select-sql... :S
>>
>>You may want to check http://berezniker.com/content/pages/visual-foxpro/queries-and-functions-which-accept-alias-parameter
>
>I read. It works in that case because VFP just open it with use again?

It works because RECNO() is used in a single-table query and w/o an alias.