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"