Matthew,
You cannot use recno() combined with sql. Remember that what goes next to the select belongs to the resulting table, not for the source.
Marc
>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
If things have the tendency to go your way, do not worry. It won't last. Jules Renard.