A colleague of mine just stumbled over a limitation regarding the number of joins within a SQL-Statement. He's got a rather complex select statement with more than ten left outer joins (?!?). When performing that select statement, he gets the error "Too many subqueries".

I just wonder whether I have to accept that limitation or am I missing something ?

Bruno