Specifications

Using Quick Select
164 InfoMaker
Example 6
This example shows the use of the word AND in the Or criteria row. In the
Criteria row,
>=500 is in the EmpId column and >=30000 is in the Salary
column. In the Or row,
AND <=1000 is in the EmpId column and AND <=50000
is in the Salary column. These criteria retrieve information for employees who
have an employee ID from 500 to 1000 and a salary from $30,000 to $50,000.
The
SELECT statement that InfoMaker creates is:
SELECT employee.emp_id,
employee.dept_id,
employee.salary
FROM employee
WHERE (((employee.emp_id >='500') AND
(employee.salary >='30000') AND
(employee.emp_id <='1000') AND
(employee.salary <='50000')))
Example 7
In a grid with three columns: emp_last_name, emp_first_name, and salary, the
expressions
LIKE C% in the Criteria row and LIKE G% in the Or row in the
emp_last_name column retrieve information for employees who have last
names that begin with C or G.
The
SELECT statement that InfoMaker creates is:
SELECT employee.emp_last_name,
employee.emp_first_name,
employee.salary
FROM employee
WHERE (((employee.emp_last_name LIKE 'C%'))OR
((employee.emp_last_name LIKE 'G%')))