Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » Error Messages » SQL Anywhere error messages » SQL Anywhere error messages sorted by message text (T-Z)


The select list for the derived table '%1' has no expression to match '%2'

ODBC 2 State 37000
ODBC 3 State 42000
Parameter 1 Name of the derived table.
Parameter 2 Name of the alias for which there is no matching expression.
Severity 15
Sybase error code 13822
Probable cause

The specified alias from the derived table's AS clause has no matching expression from the SELECT statement for that derived table. Ensure that each select list item has a matching alias in the derived table's AS clause, and vice-versa.