>thanks boris your reply,may be i write some wrong. I want.in stafft like this.
>lcode&& already have
>sec && alrdeady have
>fail && here replacement required from newt
>
>in newt table
>lcode&&c1.c2....ct
>sec&&a,b,c,d
>res10,res11,res12...res24
>
>res10,res11...res24 filed has numaric value.
>I want update res10,res11...res24 in nmt.fail
>like this
>
>lcode sec fail
>
>c1 a 18
>
>c1 b 17
>
>c2 c 19
>
>............
I am not sure what you want.
Can you post some example data and what you want from it?
I mean post some values from both tables and what you want as a final result from the data you posted.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.