UPDATE T_PUR_REGSUPPLIER  A SET( FCREATEORGID,FCTRLSTRATEGY )=(SELECT FCREATEORGID,FCTRLSTRATEGY FROM T_PUR_REGSUPPLIER_A  B WHERE A.FID=B.FID AND A.FCREATEORGID=0 AND A.FCTRLSTRATEGY=' ')
WHERE EXISTS (SELECT 1 FROM T_PUR_REGSUPPLIER_A   B WHERE B.FID = A.FID AND A.FCREATEORGID=0 AND A.FCTRLSTRATEGY=' ');
