                          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

                              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

--21 Delete combination drugs where denominators don't match
DELETE FROM ds_stage

                         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
