update yyksmx set 执行科室='c09' (select a.执行科室 from yyksmx a ,yybrryjy b where (结帐日期 between '2010-04-01' and '2010-5-1' )
and 执行科室='b011' and a.住院序号=b.住院序号 and 财务码='d11')
and 执行科室='b011' and a.住院序号=b.住院序号 and 财务码='d11')
from yyksmx a ,yybrryjy b where (结帐日期 between '2010-04-01' and '2010-5-1' )
and 执行科室='b011' and a.住院序号=b.住院序号 and 财务码='d11'
???
where 结帐日期 between '2010-04-01' and '2010-5-1'
and 执行科室='b011' and a.住院序号=b.住院序号 and 财务码='d11'
where (结帐日期 between '2010-04-01' and '2010-5-1' )
and 执行科室='b011' and a.住院序号=b.住院序号 and 财务码='d11'
执行科室='c09'
from yybrryjy b
where 结帐日期 between '2010-04-01' and '2010-5-1'
and 执行科室='b011'
and yyksmx.住院序号=b.住院序号
and 财务码='d11'
set a.执行科室='c09'
from yyksmx a ,yybrryjy b
where (结帐日期 between '2010-04-01' and '2010-5-1' )
and 执行科室='b011' and a.住院序号=b.住院序号 and 财务码='d11')