I have a query with a lot of joins in it. When I add another join, i get a 'Too Many Subqueries' error. Removing the join fixes the problem.

Is there any way around this? I am currently taking care of this with subsequent queries, but I don't much care for the way it looks.

Thanks

Russ