>Hi,
>Thank you. What if there are alot of customers?

1. Create a Stored Procedure in SQL to retrieve an XML file of customer ID's and return the order records for those customers.

2. Create temp table of cust_ids and join to the temp table.

>Again, what should I do if I want to join one VFP table and one SQL server table?

Well, 'normall' you can't. However, you could create a linked server in your SQL server... this will allow you to query the Foxdata through the SQL server and also write queries that work with both.

>Am I need to download the whole sql server table first then only can join them?

That will work, but I would try to avoid this...

BOb