select distinct(a.adcd),a.adnm from fda.ia_adc_adinfo a where not exists(select * from mde.sys_adcdyear b where a.adcd=b.code) and substr(a.adcd,5,2)!='00' and substr(a.adcd,7,15)='000000000'
验证ia_adc_adinfo表中adcd,adnm字段中数据是否在sys_adcdyear表中存在,其中adcd=code