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