Database SQL Operation: Employment.readRepresentativeEmployeeName
Description: | Returns the employer name and employee name for an employment where the employer is registered as a representative. |
Sterotype: | ns |
SELECT
ConcernRole.concernRoleName,
Representative.representativeName
INTO
:employeeName,
:employerName
FROM
ConcernRole,
Representative,
Employment
WHERE Employment.employmentID = :employmentID
AND Representative.concernRoleID = Employment.employerConcernRoleID
AND ConcernRole.concernRoleID = Employment.concernRoleID
|