Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursor
Message
 
To
16/04/2003 14:10:28
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Cursor
Miscellaneous
Thread ID:
00778480
Message ID:
00778497
Views:
16
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
Map
View

Click here to load this message in the networking platform