SELECT s.total,temp.code ,s.subject_id,temp.academicRecord_id,temp.examDate,temp.TYPE,temp.educationLevel_id FROM school_ilms.subjectresult s RIGHT JOIN ( (SELECT er.id,e.code,er.academicRecord_id,er.examDate,e.TYPE ,e.educationLevel_id FROM school_ilms.exam e RIGHT JOIN (school_ilms.examresult er ) ON (e.id=er.exam_id) WHERE e.TYPE='G' OR e.type='S') AS temp) ON(s.examResult_id=temp.id);