The query *may* run faster with subsequent queries. See the Rushmore article on my web site for more information.
>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
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer