Join Cur1 and T2 in second SELECT. If you post whole select it is much easier.
>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
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.