SELECT
  ConcernRole.concernRoleName,
  ConcernRole.primaryAlternateID,
  Utility.registeredName,
  Address.addressData,
  WebAddress.webAddress,
  PhoneNumber.phoneNumberID,
  EmailAddress.emailAddress,
  Utility.utilityTypeCode,
  Utility.nextPaymentDate
INTO
  :name,
  :primaryAlternateID,
  :registeredName,
  :addressData,
  :webAddress,
  :phoneNumberID,
  :emailAddress,
  :utilityType,
  :nextPaymentDate 
FROM
  ConcernRole 
  
  LEFT OUTER JOIN
  
  ProductProvider 
  ON (ConcernRole.concernRoleID = ProductProvider.concernRoleID) 
  
  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
  
  Utility 
  ON (ConcernRole.concernRoleID = Utility.concernRoleID) 
WHERE ConcernRole.concernRoleID = :concernRoleID