                               JOIN drug_concept_stage b ON a.drug_concept_code = b.concept_code
                             WHERE nvl(amount_unit,numerator_unit) IN ('cm','mm')
                             OR    denominator_unit IN ('cm','mm'));
-<<<<<<< HEAD
-COMMIT;
-=======
->>>>>>> 55baabc89609b7e56bf705bd362df14aada95468
+COMMIT;
 
 --21 Delete combination drugs where denominators don't match
 DELETE FROM ds_stage

                         WHERE b.concept_class_id IN ('Supplier','Dose Form','Brand Name')
                         GROUP BY a_int.concept_code_1, b.concept_class_id
                         HAVING COUNT(1) > 1)
<<<<<<< HEAD
AND NOT LOWER (c.concept_name) LIKE '%'||LOWER(b.concept_name)||'%' --Attribute is not a part of a name
--REGEXP_LIKE (c.concept_name,b.concept_name)
UNION

                         GROUP BY a_int.concept_code_1, b.concept_class_id
                         HAVING COUNT(1) > 1)
AND NOT REGEXP_LIKE (REGEXP_SUBSTR(c.concept_name,'Pack\s.*'),b.concept_name);

DELETE
FROM internal_relationship_stage
