>>>Probably I wasn't clear. Recno() has alias parameter and it works reliably under VFP9.
>>>Cetin
>>>
>>>>There's no way to specify from which table RECNO() will come from and no guaranty that it'll be correct. In general, the functions that can accept an alias as parameters are not guaranteed to work correctly when select involves more than one table. More details at http://www.berezniker.com/content/pages/visual-foxpro/queries-and-functions-which-accept-alias-parameter.
>>>>
>>>>>(at least under VFP9) recno() works perfectly well even with joins but it is deleted() that you shouldn't use with joined selects. Better do not use both for easy controlling of SQL. You didn't say what is your intention (or yuou did but I didn't get) so I don't have an idea what the SQL might look like. From the two SQLs I see I can't derive anything.
>>
>>Sure, but the Alias is out of the SQL job, then it is a fixed value.
>>
>>

>>CLOSE TABLES ALL
>>CREATE CURSOR cetin ( a i)
>>APPEND BLANK
>>SKIP  && go recno=2
>>
>>SELECT * FROM Cetin WHERE RECNO('Cetin')= 1 && not error but bad result
>>
>>SELECT * FROM Cetin X WHERE RECNO('X') = 1 && error! Alias not found
>>

>
>Do you see a problem using this? I'm using it now in a ComboBox and it appears to be working well.
>

>SELECT InsCarr.CarName, Seq, Rec FROM InsCarr JOIN (SELECT PADL( Seq_Num, 4, '0' ) AS Seq, RECNO() AS Rec, cvCarr FROM covr WITH (BUFFERING=.T.) ;
>WHERE Pat_No=Patient.PtPn AND CvPS=InsuranceLevel AND ! DELETED() ) ;
>Covr ON InsCarr.InsCarr=Covr.cvCarr ;
>ORDER BY 1 INTO CURSOR CarrierList
>