How to match the icd9_code field in the DIAGNOSES_ICD table with the icd9_code field in D_ICD_DIAGNOSES when the icd9_code of the same disease in the two tables are inconsistent?

[liedezhanghu]

I want to match the icd9_code field in the DIAGNOSES_ICD table with the icd9_code field in D_ICD_DIAGNOSES to obtain the detailed information of the patient's disease, but I find that the records of the former and the latter are not completely consistent for the same disease. How can I query to obtain the detailed disease information of the latter more accurately through the icd9_code of the former. For example, there is a record with icd9_code of '1730' in the DIAGNOSES_ICD table, but I found a record with icd9_code of '01730' when querying D_ICD_DIAGNOSES. There are many similar situations. How should we deal with them?