SELECT
  EvidenceApprovalCheck.evidenceApprovalCheckID,
  EvidenceApprovalCheck.typeCode,
  EvidenceApprovalCheck.percentage,
  EvidenceApprovalCheck.productID,
  EvidenceApprovalCheck.comments,
  EvidenceApprovalCheck.recordStatus,
  Product.name
INTO
  :evidenceApprovalCheckID,
  :typeCode,
  :percentage,
  :productID,
  :comments,
  :recordStatus,
  :productName 
FROM
  EvidenceApprovalCheck 
  
  LEFT OUTER JOIN
  
  Product 
  ON (Product.productID = EvidenceApprovalCheck.productID) 
WHERE EvidenceApprovalCheck.userName = :userName