Creating a SELECT statement - example 2
To create the example SQL SELECT statement
SELECT EMPLOYEE.JOBCODE, COUNT(*)
FROM EMPLOYEE
GROUP BY EMPLOYEE.JOBCODE
HAVING MIN(EMPLOYEE.AGE) > 40
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 the 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