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:
a. In the Connection alias field, select the connection specification for database that contains both the EMPLOYEE and WAGES tables.
b. In the Access set field, select the access set you want the SELECT statement to be created in.
c. On the Query Spec tab, select the Create push button.
2. On the SELECT Details window, do the following:
b. Select Apply.
Last modified date: 01/29/2015