select distinct ccr.Course_Name 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 Course Name</option>
<option value="Goods and Services Tax (GST)">Goods and Services Tax (GST)</option>
<option value="SAP(FICO) End User Course">SAP(FICO) End User Course</option>
<option value="Certified Industrial Accountant">Certified Industrial Accountant</option>
<option value="CIA Exemption">CIA Exemption</option>
<option value="Certified Industrial Accountant Plus">Certified Industrial Accountant Plus</option>
<option value="CIA+ Exemption">CIA+ Exemption</option>
<option value="CIA Express">CIA Express</option>
<option value="CIA Tax Professional New">CIA Tax Professional New</option>
<option value="CIA with SAP (80 Hrs)">CIA with SAP (80 Hrs)</option>
<option value="Certified Industrial Accountant Express">Certified Industrial Accountant Express</option>
<option value="Certified Industrial Accountant Foundation (CIAF)">Certified Industrial Accountant Foundation (CIAF)</option>
<option value="CIA Exemption with SAP">CIA Exemption with SAP</option>
<option value="CIA Exemption with Tally">CIA Exemption with Tally</option>
<option value="CIA with AAP">CIA with AAP</option>
<option value="Certified Industrial Accountant Foundation">Certified Industrial Accountant Foundation</option>
<option value="ICA Shine 16">ICA Shine 16</option>
<option value="Certificate in International Accounting">Certificate in International Accounting</option>
<option value="Certificate in Payroll Management">Certificate in Payroll Management</option>
<option value="Tally.ERP 9">Tally.ERP 9</option>
<option value="Hardware and Networking (ICA Shine 16)">Hardware and Networking (ICA Shine 16)</option>
<option value="LPU ICA BBA(Marketing) 2012">LPU ICA BBA(Marketing) 2012</option>
<option value="LPU ICA BCA (Programming Tools & Techniques) 2012">LPU ICA BCA (Programming Tools & Techniques) 2012</option>
<option value="LPU ICA MCA (Software Eng & Networking) 2012">LPU ICA MCA (Software Eng & Networking) 2012</option>
<option value="LPU ICA PGDCA(BUSINESS APPLICATION) 2012">LPU ICA PGDCA(BUSINESS APPLICATION) 2012</option>
<option value="Tally 100% Scholarship">Tally 100% Scholarship</option>
<option value="Excel 100% Scholarship">Excel 100% Scholarship</option>
<option value="Advanced MS Excel">Advanced MS Excel</option>
<option value="Smart Investor 2011">Smart Investor 2011</option>
<option value="LPU ICA MBA(HR Planning & Development) CONTACT 2012">LPU ICA MBA(HR Planning & Development) CONTACT 2012</option>
<option value="CIA Express - Mathabhanga College">CIA Express - Mathabhanga College</option>
<option value="NCFM-Capital Market 2011">NCFM-Capital Market 2011</option>
<option value="Business Computer Application New">Business Computer Application New</option>
<option value="CIA Foundation (CIAF)">CIA Foundation (CIAF)</option>
<option value=" CIA Foundation"> CIA Foundation</option>
<option value="CIA with SAP">CIA with SAP</option>
<option value="CIA">CIA</option>
<option value="Tally ERP 9">Tally ERP 9</option>