base a query

[maxmangion]

when you need to build a query and it is possible to either build it from a table or from another query, what is the best way to base it on:
the query or the table ?

 

[KenHigg]

Table.

???
ken

 

[maxmangion]

Thank you,

but is it possible that someone gives me some explanation why tables should be used and not queries ?

Thx

 

[KenHigg]

Humm...

If it was faster to do a query on a query, then where would you stop basing one query on another...


???
ken

 

[maxmangion]

Thx, I understand your point. Actually, i thought that it would be better to use the table, but i wasn't sure so i thought better get an advice from here.

Thanks

 

[KenHigg]

I'm sure there may be times where there would be a tangible beneifit to do a qry on a qry, just not from a performance standpoint that I can think of...

kh