Abdulla,
>I have a cursor based on a query on certain condition, now i want to retrieve data from
>another table based on each curosr rows value and some value from this row put in to another
>cursor. How will do this as SQL statement.
You can use a JOIN to pull additional columns from the other table(s). For example this selects columns from 3 related tables using 2 JOINs:
select customer.*, invoice.InvoiceNo, order.ItemDescript, order.Amount ;
from customer ;
inner join invoice ;
on customer.CustomerNo = invoice.CustomerNo ;
inner join order ;
on invoice.InvoiceNo = order.InvoiceNo ;
into cursor customerItems ;
where customer.Country = "USA"