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
Steve Medvid
Systems Analyst
Environmental Resource Management