SQL: ORDER BY clause is invalid (Error 1808)

One of the fields chosen for the ORDER BY clause is not in the SELECT list. This occurs only when using numeric indexing as in the following example where the number chosen exceeds the number of fields selected:

В	Copy Code
SELECT a,b,c FROM table ORDER BY 4

This error will also be generated if you include a Blob type field in the ORDER BY clause.

For more information, see SELECT - SQL Command.