select distinct cm.CourseType [CourseCode],cm.CourseType,case when cm.CourseType='G' then 1 when cm.CourseType='PG' then 2 when cm.CourseType='Doctral' then 3 end 'displayorder' from tblOurCourseMaster cm left join OurtblInstitute Oim on cm.OinstituteId=Oim.OinstituteId left join tblcampus campus on cm.CampusId=campus.iCampusId where 1=1