*table "newt" have lcode, sec and res10,res11....res24
*and table staff have lcode,sec and fail.
*I want to fail with res10,res11....res24 value
lcode have ="c1....ct" and also lcode contain different sec

I try but it is not easy.
UPDATE stafft ;
    SET stafft.fail = newt.res13 ,;
     SET stafft.fail = newt.res17 ;
    FROM newt; 
     WHERE stafft.lcode = "C5" AND stafft.sec="C"AND stafft.subcode="c19"