Specifications

Using Quick Select
162 InfoMaker
SQL expression examples
The first six examples in this section all refer to a grid that contains three
columns from the employee table:
emp_id, dept_id, and salary.
Example 1
The expression <50000 in the Criteria row in the salary column in the grid
retrieves information for employees whose salaries are less than $50,000.
The
SELECT statement that InfoMaker creates is:
SELECT employee.emp_id,
employee.dept_id,
employee.salary
FROM employee
WHERE employee.salary < '50000'
Example 2
The expression 100 in the Criteria row in the DeptId column in the grid
retrieves information for employees who belong to department 100.
The
SELECT statement that InfoMaker creates is:
SELECT employee.emp_id,
employee.dept_id,
employee.salary
FROM employee
WHERE employee.dept_id ='100'
Example 3
The expression >300 in the Criteria row in the EmpId column and the
expression
<50000 in the Criteria row in the Salary column in the grid retrieve
information for any employee whose employee ID is greater than 300 and
whose salary is less than $50,000.