>>Is there a way to have a value that increments by one in a SQL statement?
>>
>>

>>SELECT *, IncrementThisValueByOne FROM MyTable
>>

>>
>>To get:
>>
>>

>>MyFieldOne MyFieldTwo IncrementThisValueByOne
>>
>>Bobby      Jones      1
>>Jamie      Lee        2
>>Terry      Hatcher    3
>>

>
>Yes.
>

>select MyField1, myField2, recno() from (select myField1, myField2 from myTable...)

>
>That was a tip by Tamar Granor on the last NY User Group meeting.

Ok, I simplified the issue, but there are multiple tables and JOINs. Seems to get confused then with RECNO().