>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
There's a couple of ways you can do it... if you don't have a large amount of customers you can do something like:
SELECT *
FROM Orders
WHERE CustID IN (id1, id2, id3, id4, id5,...)
Just build the 'in' part in a scan loop first, then create your select.
BOb