| Error constant | SQLE_NO_MATCHING_SELECT_ITEM |
| 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 |
| SQLCODE | –812 |
| SQLSTATE | 42W59 |
| Sybase error code | 13822 |
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.
| Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |