It'll work as long as cursors temp1 and temp2 have the same number of records and don't have deleted records.
BTW, I don't see what's the difference between your and my code besides cursors names.

>Hi Sergey,
>
>Looking at your idea I created the following and it seems
>to work for now. I need to test it for other situations and see.
>
>SELECT aaa, bbb, RECNO() as rn ;
> FROM temp1 ;
>INTO CURSOR xxx1
>
>SELECT ccc,ddd, RECNO() as rn ;
> FROM temp2 ;
>INTO CURSOR xxx2
>
>SELECT ;
> xxx1.aaa ,;
> xxx1.bbb ,;
> xxx2.ccc ,;
> xxx2.ddd ;
>FROM ;
> xxx1 ;
>INNER JOIN XXX2 ;
> ON xxx1.rn==xxx2.rn ;
>INTO CURSOR ResultCursor
>
>Thanks,
>
>Doron
>
>>>
>>>I have 2 Cursors:
>>>Cursor A: aaa bbb ccc
>>>Cursor B: ddd eee fff
>>>
>>>I want to combine the two cursors into 1 cursor:
>>>Cusror C: aaa bbb ccc ddd eee fff <--- This is one new record
>>>
>>>I don't have an id per each cursor since cusor A or cursor B could be
>>>a JOIN of other tables as well.
>>>
>>>I could create an id per each cursor but that may take time if I have
>>>200,000 records per each cusror. Also I can not do an sql on the RECNO()
>>>of each cursor(that could be good). Each cursor has same amount of records.
>>>
>>>Any ideas are appreciated.
>>>
>>>Regards,
>>>
>>>Doron
>>You can do it using just select statements

SELECT aaa, bbb, ccc, RECNO() as rn ;
>>  FROM table1 ;
>>  INTO CURSOR temp1
>>
>>SELECT ddd, eee, fff, RECNO() as rn ;
>>  FROM table1 ;
>>  INTO CURSOR temp2
>>
>>SELECT aaa, bbb, ccc, ddd, eee, fff  ;
>>  FROM table1 Join ON temp1.rn = temp2.rn ;
>>  INTO CURSOR ResultCursor