in reply to OT: Creating tables from others
It's very hard to figure out what you are asking. This appears to be an SQL update query, but I am not entirely sure. Part of what you want looks to be:
-TatsUPDATE 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 );
|
|---|