run a series of queries

[guy]

i need to run a series of select queries which depend on the results of the
previous ones...i want to run the queries in an efficient way...

Now...first I need to run Qry1 (select records from tableA), then Qry2
(based on Qry1 results), next is Qry3 (select records from table B), last is
Qry4 (join results of Qry2 and Qry3).

How can i simplify the process? I hope I can run the several queries in a
faster way...

Thanks!

 

[Jason Lepack]

If they're just select queries then open Query4. It will do what it
needs to do with the other ones.

Cheers,
Jason Lepack