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