using a trigger to get values from one table into another

[freefony]

Am trying to get values from table tscore into table tgrade

CREATE TRIGGER qscore
ON tscore
FOR INSERT
AS
DECLARE @matno char(13)
DECLARE @score int
DECLARE @type char(30)
IF percent = 100
BEGIN
UPDATE tgrade 
SET quiz = SUM (score) AS "quizscore" FROM tscore
WHERE type = quiz AND mat_no= @matno
END

This is not working pls correct me where am wrong its urgent pls!

[ck9663]

Why do you need a trigger to do this?

-- CK

[freefony]

what else can i use

i dont know what else to use if not trigger am a begginer if there re better options please let me know