Kamal Patel just released an article on the UT that addresses how to do this using VFP. It is in the July issue of the UTMag titled "Querying ADO.NET DataSets using VFP's Data Engine"

http://www.levelextreme.com/Magazine/


>Hello everyone. Can you run a SQL select command using the two datatables in a dataset to create a third table in the dataset? If so, how is this accomplished? Thanks for the help.