>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
What about SELECT a.id,Recno("b") AS recno_b ; ...etc??? Never tried it but??
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05