Select  DISTINCT EVIDENCEDESCRIPTOR.evidenceDescriptorID, EVIDENCEDESCRIPTOR.relatedID, EVIDENCEDESCRIPTOR.evidenceType
into :evidenceDescriptorID, :relatedID, :evidenceType
 from EVIDENCEDESCRIPTOR INNER JOIN EVIDENCECHANGEHISTORY on EVIDENCEDESCRIPTOR.evidenceDescriptorID = EVIDENCECHANGEHISTORY.evidenceDescriptorID
where (changeDatetime >= :startDateTime ) and (changeDateTime<=:endDateTime ) and caseID =:caseID;