UPDATE student_attendance sa, (SELECT DISTINCT sm.reg_number, sm.id, sm.cur_academic_id, ctm.term_id, tmp.Percentage FROM tmp_attendancestatus_idcoperator131781 AS tmp, students_master sm, course_term_master ctm WHERE tmp.HallticketNumber = sm.reg_number AND ctm.term_id = sm.current_term_id AND ctm.semyear = tmp.Year AND ctm.semterm = tmp.Semester AND TRIM(STATUS) = 'Success' AND sm.college_id = 40) AS sd, tmp_attendancestatus_idcoperator131781 AS tmpup SET tmpup.tmpstatus = 1 WHERE sa.student_id = sd.id AND sa.academic_id = sd.cur_academic_id AND sa.term_id = sd.term_id AND sa.attendance_percentage = sd.Percentage AND tmpup.HallticketNumber = sd.reg_number
Quote:ERROR 1137: Can't reopen table: 'name' This error also occurs if you refer to a temporary table multiple times in a stored function under different aliases, even if the references occur in different statements within the function.
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)