update ufsystem..GL_CodeClass set cclass='损益',bcheck=1,cclass_engl='SY' where cclass in ('收入','支出') and itrade in ( select itrade_id from ufsystem..GL_BTrade where ctrade_name='行政' ) update ufdata_999_2006..code set cclass='损益',cclass_engl='SY' where cclass in ('收入','支出')