-8010: Table name must be in from list


A table name which was not listed in the FROM clause was specified in a selected column, search condition or ORDER clause.

User Action:


       1.      If a reference name was specified for a table name, use this reference name in the SQL statement.

       2.      If the FROM clause contains the specification of a table which is not included in the schema of the current database user and which is also not a system table, you need to specify the schema name for the table throughout the SQL statement.