Specifications

CHAPTER 5 Defining Reports
Users Guide 163
The
SELECT statement that InfoMaker creates is:
SELECT employee.emp_id,
employee.dept_id,
employee.salary
FROM employee
WHERE (employee.emp_id >'300') AND
employee.salary <'50000'
Example 4
The expressions 100 in the Criteria row and >300 in the Or row for the DeptId
column, together with the expression
<50000 in the Criteria row in the Salary
column, retrieve information for employees who belong to:
• Department 100 and have a salary less than $50,000
or
• A department whose ID is greater than 300, no matter what their salaries
The
SELECT statement that InfoMaker creates is:
SELECT employee.emp_id,
employee.dept_id,
employee.salary
FROM employee
WHERE (employee.dept_id = '100') AND
(emplyee.salary < '50000')OR
(employee.dept_id > '300')
Example 5
The expression IN(100,200) in the Criteria row in the DeptId column in the
grid retrieves information for employees who are in department 100 or 200.
The
SELECT statement that InfoMaker creates is:
SELECT employee.emp_id,
employee.dept_id,
employee.salary
FROM employee
WHERE employee.dept_id IN ('100,200')