Modifying SQL Queries to Retrieve Data
When data is populated in the Intelli Tips window, WinSQL Professional runs a query in the background. This query retrieves necessary records for a particular column and displays them on the screen.
A SQL query can be associated with every column in the database.
Perform the following steps to associate a query with a column.
1 Start WinSQL Professional and connect to the desired database.
2 Click the Catalog Details tab.
3 Navigate to the desired column in the left pane of the catalog tree:
4 Double-click the desired field. A window similar to the following displays:
5 Modify the query as desired, and then click OK.