ASA Error Messages
Database Error Messages
Alphabetic list of error messages
| Item | Value |
|---|---|
| SQLCODE | -812 |
| Constant | SQLE_NO_MATCHING_SELECT_ITEM |
| SQLSTATE | 42W59 |
| Sybase error code | 13822 |
| 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. |
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.