Sequential Queries

[JesseH]

Supposed you needed to run a series of queries on several files. Supposed there were 4 files external to VB.net. The first file would be "selected" using a where clause, say order date greater than 1/1/2000. The second file would be selected for customer where state = "TX". I would like to join these two resulting tables on customer number. That resulting table would be joined with the inventory master to get the product description. The idea is to create intermediate work resulting files, then join these files into new files, so on and so on. Can anybody tell me how to do this?

Thanks