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