UPDATE t_bd_supplier SET fchkisinternalcompany='1' where fid IN (SELECT fid FROM t_bd_supplier_b where finternalcompanyid>0);

UPDATE t_bd_customer SET fchkisinternalcompany='1' where fid IN (SELECT fid FROM t_bd_customer_b where finternalcompanyid>0);

UPDATE t_bd_bizpartner SET fchkisinternalcompany='1' where fid IN (SELECT fid FROM (SELECT fid FROM t_bd_bizpartner where finternalcompanyid>0) AS a);