SELECT DISTINCT ce.cisencounterid, sc.sourcetypecd, mo.organismcd,
ms.antibioticcd, ms.detailsusceptibilitycd, ms.resultcd

FROM MicroSusceptibility ms
INNER JOIN MicroOrganism mo ON ms.microorganismid = mo.microorganismid
INNER JOIN SpecimenCollected sc ON sc.specimencollectedid = mo.specimencollectedid
INNER JOIN CISTempBridge_EventID_EncID ce ON ce.CISEventId = sc.EventIdCIS