Operation Details
Description:  
Sterotype: ns
SQL 
SELECT
  ConcernRoleCommunication.subjectText,
  ConcernRoleCommunication.communicationText,
  ConcernRoleCommunication.concernRoleID,
  ConcernRoleCommunication.correspondentConcernRoleID,
  emailAddress.emailAddress
INTO
  :subjectText,
  :communicationText,
  :concernRoleID,
  :correspondentConcernRoleID,
  :emailAddress 
FROM
  ConcernRoleCommunication,
  emailAddress 
WHERE ConcernRoleCommunication.communicationID = :communicationID 
  AND emailAddress.emailAddressID = ConcernRoleCommunication.emailAddressID