If I am using an inner join on two tables and I want to get the
recno() for table b, will I get unexpected results? The VFP help says that it is not always accurate when using recno() with a join, is this true.


For example:

select a.id,recno();
from a;
inner join b on a.id = b.id;
into cursor c

Thanks,
Matt