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. :(
-----
Lee Perkins
>Hmmmm...do you have to do this with a single query? I know you could do it with three.
-----
Lee Perkins
TigerBase Technologies
"Lee is one that would plug his brain into the internet, if he could, and STILL scream for more" - Very good friend of Lee's