select distinct month(Lecture_Date) as xx,year(Lecture_Date) as YY from tbl_Lecture where year(Lecture_Date) >= '2012' and Lecture_Status = '1' Union select distinct month(Lecture_Date_2) as xx, year(Lecture_Date_2) as YY from tbl_Lecture where year(Lecture_Date_2) >= '2012' and Lecture_Status = '1' order by yy
