How many nested SELECT's

[JHausmann]

It would seem it's going to be application specific. I do not know the Access limit but SQL server 6.x can access up to 16 tables, total, at one time (7.0 can do 32). This means the total of tables in the from clause from *any* query (main or sub). I would guess that Access would be no greater than SQL Server. I could be wrong.

[Tonatiuh]

How many nested SELECT's can I do into an only one SQL statment?

Example:

SELECT * FROM table1 WHERE field1 IN(SELECT * FROM table2 WHERE field2 IN(SELECT ...


Thanks!