Background documentation-8010: Table name must be in from list Locate this document in the navigation structure

 

Exlpanation

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

User Response

  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.