- ContentsQuick LinksAccount Analysis landing page Accounting landing page AIM help AIM Receiver help Arrangements landing page Batch Processing landing page Custodian help Dashboard help Data Exchange landing page Dialer Campaigns landing page Exchange Manager help Invoices help Latitude help Latitude Console help Letter Console help Letters landing page Link Console help List Builder help Portfolio Manager help Reporting Console help Reporting landing page WorkFlow Designer help Work Queues landing page
Latitude Console Help
SQL Author
Use SQL Author to create and store custom SQL statements. The system generates SQL statements based on the settings you specify and then displays them in the lower section of the SQL Author window. You can save these statements for use in other query tools or programs.
-
Toolbar: Provides options for clearing, opening, saving, and running selection criteria, and counting the query results.
|
Option |
Description |
|
|
Clears all query settings currently displayed in the window. |
|
|
Clears the query settings currently displayed in the window and opens a saved query. |
|
|
Saves the query settings currently displayed in the window. |
|
|
Sums the number of records that match the selection criteria. |
-
Data Selection pane: Provides a list of data you can select to create a query.
-
Select Columns pane: Allows you to select and arrange the columns of data to display in the query results.
-
Conditions pane: Allows you to set the conditions for retrieving data.
-
Order pane: Allows you to set the order for displaying or running data.
-
SQL statement pane: Displays the SQL statement based on the conditions, columns, and order specified.
Related Topics