text: SELECT 
  	CONCEPT_ID_1
  , c1.CONCEPT_NAME AS CONCEPT_ID_1_NAME
  , CONCEPT_ID_2
  , c2.CONCEPT_NAME AS CONCEPT_ID_2_NAME
  , SOURCE_ID
  , EVIDENCE_TYPE
  , RELATIONSHIP_ID
  , UNIQUE_IDENTIFIER
  , UNIQUE_IDENTIFIER_TYPE
  ,	STATISTIC_VALUE
  , STATISTIC_VALUE_TYPE
  FROM @cem_schema.CEM_UNIFIED u
  	JOIN @vocabularySchema.CONCEPT c1
  		ON c1.CONCEPT_ID = u.CONCEPT_ID_1
  	JOIN @vocabularySchema.CONCEPT c2
  		ON c2.CONCEPT_ID = u.CONCEPT_ID_2
  WHERE (CONCEPT_ID_1 = @drug_id OR CONCEPT_ID_1 = @hoi_id)
  	 AND (CONCEPT_ID_2 = @drug_id OR CONCEPT_ID_2 = @hoi_id)
  ;