Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement