TABLE

This function can be used to roll a recordset to the desired table level. The function increases the flexibility of the query language by mimicking the results of rolling a selection. Effective use of this function ensures that a selection produced though a combination of interface operations (e.g. Drag and drop, roll to table level) can be accurately reproduced from a query string.

TABLE ( <table_name or expression>, <table_name> )

• table name or expression: Can be either a table name, or an expression (a query string or another query domain function) resulting in a recordset.
• table name: The table level at which the recordset resulting from the first argument should be represented.