General information
Category:
Coding, syntax & commands
Both cursors should have the field on which records should meet. And depends on how you want to join them (only those records for keyfields in both cursors or not).
keyfield,name,phone,adress
keyfield,course,age
sele curs1.*, curs2.course,curs2.age from curs1, curs2 where curs1.keyfield=curs2.keyfield.
>for example in the first record i have
>name,phone,adress
>
>in the second i have
>course,age
>
>and i want to merge this two cursor into a new one
>and it will be this
>
>name,phone,adress,course,age
Previous
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