update his_purchase set isexport = 1 where id = '2333' update b set b.recored_id = '3',b.plat_id = '55' from his_purchase e,hup_comm_list b where e.id='2333' and e.id=b.record_id
update (select e.*,b.record_id,b.plat_id from his_purchase e,hup_comm_list b where e.id='2333' and e.id=b.record_id ) set e.isexport = '1',b.record_id='3',b.plat_id='55' 用视图不知道行不行?
set isexport = 1
where id = '2333'
update b
set b.recored_id = '3',b.plat_id = '55'
from his_purchase e,hup_comm_list b
where e.id='2333' and e.id=b.record_id