Posted by Beowulf on 01/31/06 03:26

Doug wrote:
> huh. I never knew that ordering a view was unsupported. It always has
> worked, I bet it always will, but it is good to know.
>
> OTOH, if you take the EXACT same code, stuff it into a stored
> procedure, it is guaranteed to work.
>
> yet another reason not ot use views.
>
> thanks!.

I was under the impression that one cannot select from a stored
procedure or do joins with it (the way one can treat MS Access querydefs
as virtual tables).

Unfortunately, I have a large number of views that need to be joined
with physical tables and other views. As far as I know (entirely
possible I'm wrong), my options are views or user-defined functions that
return tables.

[Back to original message]