All arguments aside as to why you want RECNO(), you could do this in two stages:

SELECT *,RECNO() AS rec FROM invoice INTO CURSOR cursor_b
SELECT a.fname, a.lname, b.invoice FROM Customer a, cursor_b b WHERE a.num = b.num INTO CURSOR lcTest

>>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.