-
+-- table with mappigs to Histology code provided by CAP
 DROP TABLE cap_to_icd03_snomed_mappings;
 CREATE UNLOGGED TABLE cap_to_icd03_snomed_mappings
 (

    );

--check if target concepts exist in the concept table
SELECT *
FROM cap_breast_mapping j1
WHERE NOT EXISTS (  SELECT *

AND  m2.target_vocabulary_id<>m.target_vocabulary_id
AND (m2.target_vocabulary_id not in ('SNOMED','Nebraska Lexicon')
 OR m.target_vocabulary_id not in ('SNOMED','Nebraska Lexicon') )
order by m.s_concept_name,m2.concept_code
;


