General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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...
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only