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