Any table name in a SELECT statement may be qualified by the name of the schema to which the table belongs in the form schema.table.
Unqualified table names are implicitly qualified by the ident name of the current user.
The table name must be written in the qualified form if the schema to which it belongs was not created by the current user, unless it is replaced by a synonym.
For example:SELECT * FROM HOTELADM.ROOMTYPES;
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40