>I'm doing it with ADO.NET in VB.NET. Since I'm pulling the results of the query into an ADO.NET DataSet, and ADO.NET doesn't support doing SQL against a DataSet, I'm afraid I have to do it in one query. And since I'm dealing with VFP Free Tables and not a DBC, I can't even use views. :(
>
Who says you can't use views against free tables. I do it all the time!