ANULA VIDYALAYA
GRADE 12 - ICT (ENGLISH MEDIUM)

STUDENT ATTENDANCE FOR ONLINE CLASSES

2021.02.11 - Unit 1, Pastpaper question duscussion

PARTICIPATED LIST

ERROR: Could not able to execute SELECT Students.Class as Class, Students.FirstName as fname, Students.LastName as lname FROM `IT_AttendaceAll`, Students WHERE STATUS='Present' and Year=2021 and Month=02 and Day=11 and Students.admission=IT_AttendaceAll.admission group by Students.Class, Students.FirstName, Students.LastName. Unknown column 'Students.Class' in 'field list'

ABSENCE LIST

ERROR: Could not able to execute SELECT Students.Class as Class, Students.FirstName as fname, Students.LastName as lname, IT_AttendaceAll.Reason as Reason FROM `IT_AttendaceAll`, Students WHERE STATUS='Absent' and Year=2021 and Month=02 and Day=11 and Students.admission=IT_AttendaceAll.admission group by Students.Class, Students.FirstName, Students.LastName. Unknown column 'Students.Class' in 'field list'