Hi,

I have tables A, B and C that I've joined through a view called MYVIEW . In table B there is attribute B.orderby. It is not the primary key.

When I "SELECT * FROM MYVIEW" I always want the results ordered by B.orderby. However, an ORDER BY in a CREATE VIEW is not allowed.


Is there any way to achiev this without the ORDER BY. I think the default ordering is on the primary key of table A by default.



Thanks, Adrian

Clustered Index Not Working
Select distinct problems
Top 1 query problem
adding three fields together
UPDATE varchar(max) column using INNER JOIN with SQL2005