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.