>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.
>

You can have up to total of 9 joins/subqueries in the select. I don't think there is a limit if you use where clause to join tables.