I am trying to check on a status in table called Registration and when it is approved, I want it to insert the NRIC value into another table Houseowner. This NRIC value is obtained from the Registration table.
I somehow get an syntax error after the word END becoz the END has a underlined red line (the sort of error which is denoted when there is a spelling error in ms word) I cant get rid of the red line. I have tried to retype the whole code, delete and recreate.. the red line keeps appearing..
whats wrong with my codes? anyone pls advise... thankssss
CREATE TRIGGER DBO.InsertHouseOwner
AFTER UPDATE , INSERT
IF(StatusofAppln = "Approved")
INSERT INTO HouseOwner (NRIC)