Sorry,

I might have misunderstood your question, but if it is speed issue,

check that the fields: stafft.lcode, stafft.sec, AND stafft.subcode are all indexed. If they are not you will notice a significant speed improvement when they are indexed.

Regards

Mathias

>*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"
>

Mathias Banda

Time is longer than a rope.