MACROMEDIA COLDFUSION 4.5-DEVELOPING WEB Applications - page 69
of
380
Chapter 4: Retrieving and Formatting the Data You Want
43
SELECT Departments.Department.Name,
Employees.FirstName,
Employees.LastName,
Employees.StartDate,
Employees.Salary
FROM Departments, Employees
WHERE Departments.Department_ID = Employees.Department_ID
AND Departments.Department_Name = ’Form.Department_Name’
Employee Data Based on Criteia from Form
4
4
No records match your search criteria.
4
Please go back to the form and try again.
4
First Name | Last Name | Salary |
---|---|---|
#FirstName# | #LastName# | #Salary# |