"The select list for the derived table '%1' has no expression to match '%2'"
| Item |
Description |
|
SQLCode
|
-812L
|
|
Constant
|
NO_MATCHING_SELECT_ITEM
|
|
SQLState
|
42W59
|
|
ODBC 2 State
|
37000
|
|
ODBC 3 State
|
42000
|
|
Sybase Error Code
|
2459
|
|
Severity Code
|
15
|
|
Parameter 1
|
Name of the derived table.
|
|
Parameter 2
|
Name of the alias for which there is no matching expression.
|
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.