Database Guide


Creating a SELECT statement - example 1

To create the example SQL SELECT statement

SELECT EMPLOYEE.JOBCODE, WAGES.GROSSPAY, EMPLOYEE.NAME
   FROM EMPLOYEE, WAGES
   WHERE (EMPLOYEE.NUMBER = WAGES.EMPNUMBER) AND (EMPLOYEE.STATE = 'NC')
   ORDER BY EMPLOYEE.JOBCODE ASC, WAGES.GROSSPAY DESC

do the following:

  1. On the Multi-Row Query - Settings window, do the following:
    1. In the Connection alias field, select the connection specification for database that contains both the EMPLOYEE and WAGES tables.
    2. In the Access set field, select the access set you want the SELECT statement to be created in.
    3. On the Query Spec tab, select the Create push button.
  2. On the SELECT Details window, do the following:
    1. Specify the example SELECT statement.
    2. Select Apply.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]