select
university_info.University_Name,
university_info.Email,
university_info.Web,
university_info.Phone,
university_info.Address,
university_info.Online_Application,
program.Program_Name,
subject.Subject_Name,
univ_circular.Session,
univ_circular.Requirements,
date_format(univ_circular.Form_Start_Date,'%d-%m-%Y') as Form_Start_Date,
date_format(univ_circular.Form_End_Date,'%d-%m-%Y') as Form_End_Date,
univ_circular.Form_Collection_Procedure,
date_format(univ_circular.Submission_Start_Date,'%d-%m-%Y') as Submission_Start_Date,
date_format(univ_circular.Submission_End_Date,'%d-%m-%Y') as Submission_End_Date,
univ_circular.Submission_Procedure,
date_format(univ_circular.Candidate_Published_Date,'%d-%m-%Y') as Candidate_Published_Date,
date_format(univ_circular.Test_Date,'%d-%m-%Y') as Test_Date,
Hour(univ_circular.Test_Time) as Test_Time_hh, Minute(univ_circular.Test_Time) as Test_Time_min,
date_format(univ_circular.Result_Date,'%d-%m-%Y') as Result_Date,
date_format(univ_circular.Merit_Admission_Start_Date,'%d-%m-%Y') as Merit_Admission_Start_Date,
date_format(univ_circular.Merit_Admission_End_Date,'%d-%m-%Y') as Merit_Admission_End_Date,
date_format(univ_circular.Waiting_Admission_Start_Date,'%d-%m-%Y') as Waiting_Admission_Start_Date,
date_format(univ_circular.Waiting_Admission_End_Date,'%d-%m-%Y') as Waiting_Admission_End_Date,
date_format(univ_circular.Class_Start_Date,'%d-%m-%Y') as Class_Start_Date
from
univ_circular, subject, university_info, program
where
univ_circular.Circular_ID='' and
university_info.University_ID='' and
university_info.University_ID=univ_circular.University_ID and
program.Program_ID='' and
program.Program_ID=univ_circular.Program_ID and
subject.Subject_ID='' and
subject.Subject_ID=univ_circular.Subject_ID