General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Combine 2 or more cursors
Hi All,
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only