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'
<option selected="selected" value="">Select State Name</option>
<option value="Gujarat" >Gujarat</option>
<option value="Maharashtra" >Maharashtra</option>
<option value="Uttar Pradesh" >Uttar Pradesh</option>
<option value="Rajasthan" >Rajasthan</option>
<option value="Haryana" >Haryana</option>
<option value="West Bengal" >West Bengal</option>
<option value="Karnataka" >Karnataka</option>
<option value="Bihar" >Bihar</option>
<option value="Punjab" >Punjab</option>
<option value="Chattisgarh" >Chattisgarh</option>
<option value="Kerala" >Kerala</option>
<option value="Uttarakhand" >Uttarakhand</option>
<option value="Jharkhand" >Jharkhand</option>
<option value="Delhi" >Delhi</option>
<option value="Telangana" >Telangana</option>
<option value="Assam" >Assam</option>
<option value="Odisha" >Odisha</option>
<option value="Silvassa (UT)" >Silvassa (UT)</option>
<option value="Tamilnadu" >Tamilnadu</option>
<option value="Jammu" >Jammu</option>
<option value="Madhya Pradesh" >Madhya Pradesh</option>
<option value="Andhra Pradesh" >Andhra Pradesh</option>