SELECT E.EmployeeID, E.FirstName, E.LastName, E.Title, D.DepartmentName, E.PhoneExtension, E.EmailAddress, E.HomeAddress
FROM Employees E, Departments D
WHERE EmployeeID = #url.EmployeeID# AND E.DepartmentID = D.DepartmentID;
Record, EmployeeID = #url.EmployeeID#, does not exist in the Database.
GO BACK
| EmployeeID |
#EmployeeID# |
| Name (Last, First) |
#LastName#, #FirstName# |
| Title |
#Title# |
| DepartmentName |
#DepartmentName# |
| PhoneExtension |
#PhoneExtension# |
| EmailAddress |
#EmailAddress# |
| HomeAddress |
#HomeAddress# |
GO BACK