SQL tab

This tab is available for Advanced SPC Retrievals and Advanced DMS Retrievals.

On this tab, you must enter an SQL SELECT query to return values from one or more tables in the current database connection.

Because this type of retrieval is designed only for maintaining imported Legacy reports, you can find more tips for creating this SQL SELECT query in the documentation for Legacy Dynamic Reports.

(When you use the Preview tab to test your query, clearing the Limit to 5 rows check box will display up to 200 rows returned by the query.)