UPDATE A
SET NAME =(SELECT A.NAME FROM B WHERE A.ID=B.ID)WHERE EXISTS(SELECT * FROM T_ZQB_LK WHERE T_ZQB_LK.XSTM=T_GOODSSTOCK_LOCK.XSTM) ;
UPDATE A
SET NAME =(SELECT A.NAME FROM B WHERE A.ID=B.ID)WHERE EXISTS(SELECT * FROM T_ZQB_LK WHERE T_ZQB_LK.XSTM=T_GOODSSTOCK_LOCK.XSTM) ;