UPDATE total_scores
SET total_score = score
FROM scores AS sub
WHERE total_scores.student_code = sub.student_code;

select * from total_scores