Doing a SELECT * FROM Filename simply opens the table with another alias .. in other words, it's the same table.
FYI...WHen you try to use RECNO() in a SELECT with multiple tables, the results of RECNO() cannot be trusted. See the Help file for more information.
>how can i view the record nos along with the table
>
>sele * from filename does not allow me to view the recordnos, neither does
>
>sele fieldname1,fieldname2,recn()
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer