gwp issue之后的voucher 如果要修改campany还需要修改voucher_request_approve里的campaign_id 和voucher_campaign_issue_request里的request_remarks
select d.voucher_id , a.request_id, b.campaign_id, e.campaign_id from voucher_request_approve a, voucher_campaign_issue_request b, voucher_batch_no_section c, voucher d, voucher_campaign_issue e where a.request_id = b.request_id and a.batch_id = c.batch_id and d.prefix = c.prefix and c.start_no = d.voucher_no and c.end_no = d.voucher_no and d.voucher_id = e.voucher_id and b.campaign_id != e.campaign_id UPDATE voucher_campaign_issue_request set campaign_id = 26 where request_id in (6843, 7191, 7754, 8264) select * from voucher_request_approve where request_id in (6843, 7191, 7754, 8264) select * from voucher_campaign where campaign_id = 26