>I am attempting to create a view within SQL Server 6.5 (I don't think we added any service packs yet). It is a simple query:
>SELECT * from Building Order by Building_no.
>This returns a syntax error on the Order by statement. Any clues are appreciated. I checked MS KB, Tech Net, Manuals and everything says that this should work... The error message is 156 Incorrect syntax near Order.
>tia
>
>Steve

I just found a note in a third party book that says ORDER BY is not permitted in a view. What is this?