Skip to main content

SQL Query Wizard

  1. Last updated
  2. Save as PDF

Create SQL queries.

  1. Right-click the SQL Query field.
  2. Select SQL Query Wizard > Build Query from the right-click menu.
  3. Select Build Query
    • The select statement is used to query the database and retrieve selected data that match the criteria that you specify. Here is the format of a simple select statement:
    • The column names that follow the select keyword determine which columns will be returned in the results. Multiple column names can be queried.
    • The table name that follows the keyword FROM specifies the table that will be queried to retrieve the desired results.
Build a SELECT clause

Using the following format: SELECT 'sqlschema.tablename.fieldname' FROM 'sqlschema.tablename'

  1. The Tablename dialog displays. Select the table, click Ok.
  2. The 'Field for SELECT clause' dialog displays. Select the field, click Ok.
    • Fields in the SQL table are available.
Insert a WHERE Clause

The where clause (optional) specifies which data values or rows will be returned or displayed, based on the criteria described after the keyword WHERE.

  1. The 'Field for WHERE clause' dialog displays. Select the field, click Ok.
  2. The 'Comparison for WHERE clause' dialog displays. Select the field to compare, click Ok.
    • The field is used to refine the results set to return values associated with the value selected in this field.
    • Fields in the SQL table are available.
  3. The 'Type of Comparison' dialog displays. Select the comparison type, click Ok.
    • If Specific Value is selected, the Specific Value dialog displays.
  4. Enter the value, click Ok.
  5. The 'Type of Comparison' dialog displays. Select the comparison type, click Ok.
Insert a SELECT Clause with CODE and VALUE
  1. The 'Code Field for SELECT clause' dialog displays. Select the code, click Ok.
  2. The 'Value Field for SELECT clause' dialog displays. Select the value, click Ok.
Check the SQL query for validity

  • Click Validate SQL Query
    The SQL is verified that it complies the standard SQL syntax.
    The Validate SQL Query button is enabled.

See Create SQL Queries for more information.

See SQL Reserved Words for a list of words that cannot be used in SQL table names.