> 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