select a.accounttype,a.cbdcode,a.mdcs_type,a.persontype from ybgl_syboutaccount a where a.accounttype like '%005%'; update ybgl_syboutaccount a set a.accounttype='006-3' where a.accounttype like '%005%' and a.cbdcode='421121' and a.mdcs_type='310' and a.persontype='12'; update fee_out_account a set a.accept_type=(select b.accounttype from ybgl_syboutaccount b where b.hisaccountno=a.account_no) where a.account_type like '%005%'; select * from fee_out_account a where a.account_type like '%005%'; select a.hisaccounttype,a.cbdcode,a.mdcs_type,a.persontype from ybgl_sgainpatientinf a where a.hisaccounttype like '%005%'; update ybgl_sgainpatientinf a set a.hisaccounttype='006-42' where a.hisaccounttype like '%005%' and a.cbdcode='421102' and a.mdcs_type='310' and a.persontype='11'; update Fee_In_Account a set a.account_type=(select b.hisaccounttype from ybgl_sgainpatientinf b where b.accountno=a.account_id) where a.account_type like '%005%'; select * from cis_inpatient a where a."ACCOUNT_TYPE" like '%005%'
