I am getting error 1805 Too Many Subqueries when executing an SQL query.
The help file says there is a limit of 2 subqueries.

the select statement that failed has 6 sub-select statements, if I remove one it works fine. I also found if I keep the 6 sub-queries and remove a join condition from the where clause it also works fine.

Basically if i have almost any combination of JOIN conditions and subqueries up to a total of 10 ( between them) it is OK, but as soon as I try for 11 it gives error 1805.

I have found several ways around the problem , but was just wondering if someone could shed some light on this.