>
>In my table
>field are. lcode sec math science English Urdu
> c5 A 18 12 13 10
>in stafft table
>my final result is :
>
>lcode sec subject fail
>
>c5 a math 18
>
>c6 b science 12
>.......

No, I want Structure of the BOTH tables, some example records in BOTH tables and what you want as the result after the UPDATE.

Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.