run a series of queries

  • Thread starter Thread starter guy
  • Start date Start date
G

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!
 
If they're just select queries then open Query4. It will do what it
needs to do with the other ones.

Cheers,
Jason Lepack
 
Back
Top