Operation Details
Description: Searches across the EvidenceDescriptor table by case ID for records that exist on the CoCEvidenceLink table and are associated with tha case ID.
Sterotype: nsmulti
SQL 
SELECT
  CoCEvidenceLink.evidenceLinkID,
  CoCEvidenceLink.evidenceDescriptorID,
  CoCEvidenceLink.username,
  CoCEvidenceLink.timestamp
INTO
 :evidenceLinkID,
 :evidenceDescriptorID,
 :username,
 :timestamp
FROM
  CoCEvidenceLink,
  EvidenceDescriptor
WHERE
  EvidenceDescriptor.caseID = :caseID AND
  CoCEvidenceLink.evidenceDescriptorID = EvidenceDescriptor.evidenceDescriptorID