Using an Alias for a Supertable

An alias is a word that immediately follows the name of a table in the FROM clause. You can specify an alias for a typed table in a SELECT or UPDATE statement and then use the alias as an expression by itself. If you create an alias for a supertable, the alias can represent values from the supertable or the subtables that inherit from the supertable. In DB–Access, Figure 161 returns row values for all instances of the person, employee, and sales_rep tables.

SELECT p FROM person p

ESQL/C does not recognize this construct. In an ESQL/C program, Figure 161 returns an error.