(code, sub_namesub_passMarks, sub_internalPassmarks)
(101, English, 32, 12)
(Roll_No, 101, 101_nt)
(24514, 35, 8)
i have two tables first one is subject table and second one is student table..i want o write a trigger to generate "backlickStatus"
the student table field compare with the subject table code and check whether the student marks are greater than then update status as pass
other wise fail in "back-lock status"(it another table status)
THANK YOU IN ADVANCE