- style
YOU ARE CURRENTLY ACCESSING AN OUTDATED VERSION OF THE ZOOLA HELP DOCUMENTATION
Go to https://help.zoola.io for up-to-date documentation, videos, walkthroughs, and case studies.
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:
In the Query ID field, type a name for the table.
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 - { ; }
When the query is complete, click the Run Query button to test it and choose the list of columns from the results.
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.
Click the Save Table button to add the derived table to the Available Objects panel.
.
Copyright © Lambda Zoola™