| Operation Details |  |
| Description: | Returns the employer name and employee name for an employment. |
| Sterotype: | ns |
| SQL | |
SELECT ConcernRole.concernRoleName, Employer.tradingName INTO :employeeName, :employerName FROM ConcernRole, Employer, Employment WHERE Employment.employmentID = :employmentID AND Employer.concernRoleID = Employment.employerConcernRoleID AND ConcernRole.concernRoleID = Employment.concernRoleID |