SELECT
  ConcernRole.primaryPhoneNumberID, 
  EmailAddress.emailAddress,
  Address.addressData
INTO
  :phoneNumberID,
  :emailAddress,
  :addressData
FROM
  ConcernRole
  LEFT OUTER JOIN EmailAddress 
    ON ConcernRole.primaryEmailAddressID = EmailAddress.emailAddressID
  LEFT OUTER JOIN Address 
    ON ConcernRole.primaryAddressID = Address.addressID
WHERE ConcernRole.concernRoleID = :concernRoleID