SELECT
  DISTINCT CR2.concernRoleType
INTO
  :concernRoleType
FROM
  ConcernRole INNER JOIN ConcernRole CR2 ON ConcernRole.concernID = CR2.concernID
WHERE
 ConcernRole.concernRoleID = :concernRoleID