>>I'm surprised at you guys! < BG > You know you can't use an alias name in a SQL SELECT statement for RECNO(). It's clearly stated in the docs.
>
>Yeah yeah. I tried it and leanred somethings. This made me think:
>
>select recno('table'), * from table
>
>works, but
>
>select recno('tablex'), * from table as tablex
>
>threw an "Alias" not found.

I've never tried it even when there was only a single table in the select. And I never even thought about trying it with the SQL alias to the table...