Erik,

Well the first reason is I need to have more tables joined than is allowed in a single SQL.

Any ideas?

TIA

Rex

>>In this case, no UDFs
>>
>>This is a view based on another view.
>
>Ahh, why didn't you say so? :-)
>
>You've run into one of the many reasons that you should try avoiding building views based on views. The first thing I should ask you is... why? Nearly all of the time I see someone do this, they could have done the same thing with a single view. If you owuld like, post the SQL to both of your views here, and we'll see how we can fix the situation...