How many queries

[BB]

A newbie question:
I know you can query a query, but how many levels of queries can you do?? For example, can I do a union query on several queries, which some of them may be based on a query, and then do a query on the union query?

Thanks for any comments!

 

[pcs]

the answer is it depends...the max number of nested queries is 50 and a max of 32 tables.

but you may take performance hits before the maximum number is reached. you also may encounter 'too complex to evaluate' errors.

i have done some pretty deep nesting with no problems and good performance.

i'm not sure how much union queries impact this.

best advice is to try it...

hth,
al