The Derived Tables Tab

You create a derived table in a Domain by first building a custom query using the objects you selected on the Tables tab. You first run the query, and then select columns from the query result for use in the Domain design.

To define a derived table, complete the following steps:

1. In the Query ID field, type a name for the table.

2. In the Query field, enter a valid SQL query. The query may refer to any table or column in the Available objects panel. Only queries that begin with the select statement are allowed. Do not include a closing semi-colon - { ; }
   
   

   TipExpand the tables in the Available Objects panel. Double-click the column names to add them to the query.

3. When the query is complete, click the Run Query button to test it and choose the list of columns from the results.

4. By default, all columns in the query results are selected. Use Ctrl+Click to change the selection. If you want only a few columns out of many, it is easier to specify the column names in the "SELECT" clause of the query.

5. Click the Save Table button to add the derived table to the Available Objects panel.