Enterprise Edition Home | Express Edition Home | Previous Page | Next Page   SQL Statements > SELECT >

The ONLY Keyword (IDS)

If the SELECT statement queries a supertable, rows from both the supertable and its subtables are returned. To query rows from the supertable only, you must include the ONLY keyword in the FROM clause, as in this example:

SELECT * FROM ONLY(super_tab)
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]