Using SQL Select

When you specify data for a DataWindow object, SQL Select provides more options for specifying complex SQL statements when you use SQL Select rather than Quick Select.

When you choose SQL Select, you go to the SQL Select painter, where you can paint a SELECT statement that includes:

• More than one table
• Selection criteria (WHERE clause)
• Sorting criteria (ORDER BY clause)
• Grouping criteria (GROUP BY and HAVING clauses)
• Computed columns
• One or more arguments to be supplied at runtime

• Defining the Data Using SQL Select
  Use the SQL Select painter to define a SQL statement to retrieve data for the DataWindow object.
• Selecting Tables and Views Using SQL Select
  Select the tables and views to include in a query. The tables and views that are available depend on the DBMS.
• Table Layout View in SQL Select
  The Table Layout View in the SQL Select dialog shows representations of any tables and views you select.
• Selecting Columns Using SQL Select
  In the Table Layout view, click each column to include from the table representations.
• Including Computed Columns Using SQL Select
  Computed columns that you define in the SQL Select painter are added to the SQL statement and used by the DBMS to retrieve the data. The expressions you define here follow your DBMS's rules.