SELECT
  ConcernRole.concernRoleName,
  InformationProvider.typeCode,
  ConcernRole.primaryAlternateID,
  Address.addressData,
  WebAddress.webAddress,
  PhoneNumber.phoneNumberID,
  EmailAddress.emailAddress
INTO
  :name,
  :informationProviderType,
  :primaryAlternateID,
  :addressData,
  :webAddress,
  :phoneNumberID,
  :emailAddress 
FROM
  ConcernRole 
  LEFT OUTER JOIN
  Address 
  ON (ConcernRole.primaryAddressID = Address.addressID) 
  LEFT OUTER JOIN
  WebAddress 
  ON (ConcernRole.primaryWebAddressID = WebAddress.webAddressID) 
  LEFT OUTER JOIN
  PhoneNumber 
  ON (ConcernRole.primaryPhoneNumberID = PhoneNumber.phoneNumberID) 
  
  LEFT OUTER JOIN
  
  EmailAddress 
  ON (ConcernRole.primaryEmailAddressID = EmailAddress.emailAddressID) 
  
  LEFT OUTER JOIN
  
  InformationProvider 
  ON (ConcernRole.concernRoleID = InformationProvider.concernRoleID) 
WHERE ConcernRole.concernRoleID = :concernRoleID