>Hi,
>I have a VFP cursor result contains customer records. I want to query all order transactions placed by these customers. How the sql statement look like to send to sql server?
>
>Thank you
hi,
one way would be

sqlexec(han,"select cus_id into #temp from customer where 1 = 0")

now populate the #temp table created on the sqlserver with the cus_id which u have.

then use innerjoin to retrve a view.

sqlexec(han,"select customer.* from customer inner join "+;
             "#temp on customer.cus_id = #temp.cus_id","cursor")

Well a round a way approach but helps.