Running queries

[accessman2]

Hi,

I did 2 ways:

If I created a query named qry1,
then, I created another query (qry2) which include qry1.
Is that meaning running 2 queries?
Firstly, run qry1 result, then run qry2.

Please let me know, thanks.

 

[pbaldy]

Presuming you mean SELECT queries, all you have to do is run query 2; it will run query 1 in the background.

 

[accessman2]

So, it will be run slowly, right.

Actually, the query2 can retrieve the result from the table directly.

But, I created the qry1 to limit the results, and then make qry 2 to retreive the results from qry1. So, it runs 2 queries, it is a bit slowly, right.

 

[RV]

So, it runs 2 queries, it is a bit slowly, right.

Not necessarily, no.

RV