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