If you want to do it with a SQL command, I think this is what you are after:

update inwardl set ;
    vattype = pc.vattype ;
  from inwardl iw ;
    inner join pcodel pc ;
      on iw.pcode = pc.pcode

HTH,
Chad

>below command not update all the records in "inward1.dbf"
>

>sele 0
>use pcode1
>sele 0
>use inward1
>update inward1 set inward1.vattype=pcode1.vattype where inward1.pcode = pcode1.pcode
>
>

>
>
>warm regards,
>mk.