Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Why will this work in query analyzer but not aview

Author  Topic  sqluser Starting Member 6 Posts Posted - 2001-05-11 : 10:05:03 The following code will work in query analyzer and do what I expect it to, but when I try to cut and paste it into a view I get this error: "Order by clause may not be used in this query type" Here is the SQL select [levelid],[subject] , [title], [description], [numq] from All_Comps order by [levelid], [subject]