SELECT biodata.bd_serial, biodata.bd_apl_tserial, biodata.bd_apl_serial, biodata.bd_name, biodata.bd_fname, studentmaster.sm_sescode, studentmaster.sm_clcode, studentmaster.sm_confirmed, CONCAT(biodata.bd_board,'-',biodata.bd_boardyear,'-',biodata.bd_boardroll) AS boarddetails, subjectmaster.sub_name, applitrans.admissionslipgenerated, applitrans.admitted FROM biodata INNER JOIN studentmaster ON biodata.bd_serial = studentmaster.sm_bdserial INNER JOIN `subjectmaster` ON studentmaster.sm_subjectcode = `subjectmaster`.sub_sl INNER JOIN applitrans ON biodata.bd_apl_tserial = applitrans.aptserial WHERE applitrans.admitted='0' AND studentmaster.sm_sescode=2324 Unable to open My Admission