Information générale
Titre:
Retrive data from Sql table based on resulted Cursor
Versions des environnements
Network:
Windows 2000 Server
Dear Experts,
I have a Cursor populated from the table based on certain query coditions,
Now, i want to retrieve data from another table base on some matching coditions
with some fields from the current cursor.
Ie,
Vfp Command is like
Select F1,F2 From table (T1) Where (Some conditons) in to cursor Cur1
Select Cur1.F2, T2.F3, T2.F4 From table (T2) Where Cur1.F1 = (Some conditions)
Into Cursor Cur2
Sele Cur2
Brow
How i will do it with Sql Server command.
Thanks in advance
With thanks and regards
Abdulla
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