The majority of users don't need to access the custom SQL area. Familiarity with SQL and FH data structures is required to customize queries using SQL. If you have created a new query and want to create a query manually using SQL commands, complete the following steps with the Query Designer form displayed:
-
From the Tools menu select the Queries... option.
The Queries form is displayed.
-
Select the module and record area, and either create a new query, or modify an existing query.
Information on creating or modifying a query is available in Create New Query and Modify Query.
-
In the Query Designer form, in the Options area, check Define query manually through custom SQL commands.
The View SQL button changes to Customize SQL.
-
Press Customize SQL.
The Query-Customize SQL form is displayed.
-
Type valid SQL commands and FH data tables and fields.
Related Topics: