update t_tctb_declare_main t set ftaxauthority =(select ftaxoffice from t_tctb_tax_main m where m.ftaxorg  = t.forgid)
 where t.fnsrtype in ('draft_zzsxgmnsr','draft_zzsybnsr','draft_zzsybnsr_ybhz','fjsf','qysds_hdzs_nb','qysdsjb','qysdsnb','qysdsnb_dg', 'zzsaccount','zzsaccountmonth','zzsxgmnsr','zzsybnsr','zzsybnsr_ybhz','zzsyjskb');