SELECT
  ContactLogAttendee.contactLogAttendeeID,
  ContactLogAttendee.concernRoleID,
  ContactLogAttendee.userName,
  ConcernRole.concernRoleName
INTO
  :contactLogAttendeeID,
  :concernRoleID,
  :userName,
  :concernRoleName 
FROM
  ContactLog,
  ContactLogLink,
  ContactLogAttendee 
  
  LEFT OUTER JOIN
  
  ConcernRole 
  ON ConcernRole.concernRoleID = ContactLogAttendee.concernRoleID 
WHERE ContactLogLink.linkID = :linkID 
  AND ContactLogLink.linkType = :linkType 
  AND ContactLogLink.contactLogID = ContactLog.contactLogID 
  AND ContactLog.contactLogID = ContactLogAttendee.contactLogID 
  AND ContactLogAttendee.recordStatus = :recordStatus