UPDATE ICD_9_Disease_Types
SET    Circulatory_Disease = 1
WHERE  CHD in (
SELECT ICD_9
FROM   ICD_9,
       ICD_specifications_for_disease
WHERE  ICD_9.ICD_9 BETWEEN
       ICD_specifications_for_disease.ICD_start
AND    ICD_specifications_for_disease.ICD_end
       );