- Contents
SQL Author
Use SQL Author to create and store custom SQL statements. The system generates SQL statements based on the settings you specify and 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 section: Displays the SQL statement based on the conditions, columns, and order specified.