CCCC=select distinct cm.State from center_master cm inner join center_course_relation ccr on cm.Center_Code=ccr.Center_Code where cm.State!='' and ccr.Active='Yes'