SELECT
  ProspectPerson.specialInterestCode,
  ProspectPerson.comments,
  ProspectPerson.fromAge,
  ProspectPerson.toAge,
  ProspectPerson.versionNo,
  ConcernRole.registrationDate,
  ConcernRole.sensitivity,
  ConcernRole.prefPublicOfficeID
INTO
  :specialInterestCode,
  :comments,
  :fromAge,
  :toAge,
  :versionNo,
  :registrationDate,
  :sensitivity,
  :prefPublicOfficeID
FROM
  ProspectPerson,
  ConcernRole
WHERE ProspectPerson.concernRoleID = :concernRoleID 
  AND ConcernRole.concernRoleID = :concernRoleID