Selecting Rows from a Supertable with the ONLY Keyword

Although a SELECT statement on a supertable returns rows from both the supertable and its subtables, you cannot tell which rows come from the supertable and which rows come from the subtables. To limit the results of a query to the supertable only, you must include the ONLY keyword in the SELECT statement. For example, Figure 159 returns rows in the person table only.

SELECT * FROM ONLY(person)

name        Rogers, J.
address     ROW(102 Ruby Ave, Belmont, CA, 69055)
soc_sec     454849344

·
·
·