2/2563 |
1 Unknown column 'dba_student.cla_id' in 'where clause' SELECT dba_student.*,
dba_sub_departmet_stu.sdep_name,
dba_department_stu.dep_name,
dba_student.stu_year_entry,
dba_sub_departmet_stu.sdep_extname,
dba_sub_departmet_stu.sdep_remark,
dba_student_type.stt_description,
dba_class.cla_name,dba_class.cla_extname
FROM dba_student
LEFT JOIN dba_sub_departmet_stu ON dba_student.cla_id=dba_sub_departmet_stu.cla_id
and dba_student.fac_id=dba_sub_departmet_stu.fac_id
and dba_student.dep_id=dba_sub_departmet_stu.dep_id
and dba_student.sdep_id=dba_sub_departmet_stu.sdep_id
LEFT JOIN dba_department_stu ON
dba_student.cla_id=dba_department_stu.cla_id
and dba_student.fac_id=dba_department_stu.fac_id
and dba_student.dep_id=dba_department_stu.dep_id
LEFT JOIN dba_class ON
dba_student.cla_id=dba_class.cla_id
LEFT JOIN dba_student_type ON
dba_student.stu_stt_id=dba_student_type.stt_id WHERE dba_student.stu_stt_id='2' and dba_student.cla_id='02' and dba_student.fac_id='1' and dba_student.dep_id='06' and dba_student.sdep_id='02' and dba_student.stu_year_entry='2563' and dba_student.sec_room='2' ORDER BY sec_room,sec_group,stu_id |