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