(code, sub_namesub_passMarks, sub_internalPassmarks)
(101, English, 32, 12)
(Roll_No, 101, 101_nt)
(24514, 35, 8)
(Roll_No,Backlock Status)
i have two tables first one is subject table and second one is student table..i want o write a trigger to generate "backlickStatus"
like
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)
PRIMARY KEYS-CODE,ROLL_NO
THANK YOU IN ADVANCE
|
