Database Guide
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:
- On the Multi-Row Query - Settings window, do the following:
- In the Connection alias field, select the connection
specification for the database that contains both the EMPLOYEE and WAGES
tables.
- In the Access set field, select the access set you want the
SELECT statement to be created in.
- On the Query Spec tab, select the Create push button.
- On the SELECT Details window, do the following:
- Specify the example SELECT statement.
- Select Apply.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]