>It seems you're correct. If I eliminate everything but 9 joins, it works fine. But I was under the impression after looking at the documentation that a subquery would be another SQL Select statement encased in () and would be in a WHERE clause. Very confusing. I don't guess you know if SQL Server has the same limitations do you?
You guessed right :) I don't know how SQL server limits it (if it does).
Cetin