>Terry,
>
>This is off-the-wall and I haven't tested it, but what about this:
>
>SELECT RECNO('invoice') AS invrec, a.fname, a.lname, b.invoice FROM Customer a, Invoice b WHERE a.num = b.num INTO CURSOR lcTest
>
>Note the change to how RECNO() is being used.
>
>
>>Hello,
>>
>> I want to display the record number of my customer table from SELECT-SQL. I am able to do this when I use only the customer table, but if I join another table, I am unable to display the record number from the customer table.
>>
>> If I issue: "SELECT RECNO(), fname, lname FROM Customer INTO CURSOR lcTest," I get Customer.dbf's record number for each record.
>>
>> If I now join a second table into the SELECT-SQL, i.e., If I issue: "SELECT RECNO(), a.fname, a.lname, b.invoice FROM Customer a, Invoice b WHERE a.num = b.num INTO CURSOR lcTest," I get a record number, but it is not the record number from the Customer table, which is what I want.
>>
>> Does anyone know how I can get the record number from the first table?
Hi John,
I tried the SELECT as you wrote it RECNO('table'). I got the record number for one table - repeated for each record.
Thanks for the thought.
Thanks,
TFISHER