Corporate Intranet Directory

SELECT E.EmployeeID, E.FirstName, E.LastName, E.Title, D.DepartmentName, E.PhoneExtension, E.EmailAddress FROM Employees E, Departments D WHERE E.DepartmentID = D.DepartmentID ORDER BY E.FirstName DESC; SELECT FirstName,LastName FROM Employees WHERE ManOfTheMonth='yes';

#applicationName#
Employee of the Month: #FirstName# #LastName#
ID	Name (Last, First)	Title	Department Name	Phone Extension	Email Address
	#LastName#, #FirstName#	#Title#	#DepartmentName#	#PhoneExtension#	#EmailAddress#

Select an Employee ID radio button prior to clicking the 'Update Employee' or 'Delete Employee' buttons.