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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-18 : 09:34:34
|
| IIS Team writes "When trying to sort a table using a standard SELECT statement i.e. SELECT * FROM visitor_bookings ORDER BY visitor_booking_code, we get the following error:-Microsoft OLE DB Provider for SQL Server (0x80040E14)Column name 'visitor_bookings.visitor_booking_code' is invalid in the ORDER BY clause because it is not contained in an aggregate function and there is no GROUP BY clause." |
|
|
|
|
|
SQL Server using OLE DB won't accept ORDER BY unless there is a GROUP BY