Queries on tables vs Nested queries 1

[jamaarneen]

Hi everyone,
I'm new, so...

is there ANY difference between queries build direct on tables and queries build on other queries (=nested queries)?

well, nested queries would obviously be more easy to create, but my question is, if there might be any diffrences for the stability or something else?

Thanks,Ja

 

[fneily]

Depends on the situation and your relationships. Sometimes you can get what you need by querying the tables directly, sometimes not.
If it's your database, and your good at advance coding, then you can make complex nested queries.
If you're dealing with people who'll maintain the database or may not be that good at following a language then I'd suggest you do it modularly. Separate queries - easy to understand and maintain.
If you look at some of the answers given in the VBA and SQL Access forums, you'll see that some people like to show their talents and do five steps in one. But for the general users, it may be better to do five steps in five.
As for stability, speed, etc. not much.

 

[jamaarneen]

Thanks for your advise, fneily.