Posted by Serge Rielau on 01/26/06 17:14

Beowulf wrote:
> Tables are unordered, but a view's not a table, as far as I understand
> it. It is a stored pre-compiled select statement that allows you to
> view table data the way you want. Coming from Acess, I expect to be
> able to have views be ordered if I include an ORDER BY clause. As it
> turns out, I can't expect that from SQL Server. Now I know.
The result of any relational operation (UNION, EXCEPT, SELECT...) is a
table. Just a derived table as opposed to a base table.
It is the transitive closure that's part of SQL's power.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
DB2 UDB for Linux, Unix, Windows
IBM Toronto Lab

• Next in forum: Formula Parsing
• Prev in forum: Re: ORDER BY in VIEW not working
• Thread view: Re: ORDER BY in VIEW not working

[Reply to this message]