批量update 表1的数据，数据从查询中获取
update cux.gm_js_prices t
set t.start_date = (select pha.start_date
from cux.gm_js_prices gjp, po.po_headers_all pha
where gjp.rqf_header_id = pha.po_header_id
and (gjp.start_date <> pha.start_date or
gjp.end_date <> pha.end_date)
and t.header_id = gjp.header_id)
,t.end_date = (select pha.end_date
from cux.gm_js_prices gjp, po.po_headers_all pha
where gjp.rqf_header_id = pha.po_header_id
and (gjp.start_date <> pha.start_date or
gjp.end_date <> pha.end_date)
and t.header_id = gjp.header_id)
where t.header_id in (
select gjp.header_id
from cux.gm_js_prices gjp, po.po_headers_all pha
where gjp.rqf_header_id = pha.po_header_id
and (gjp.start_date <> pha.start_date or
gjp.end_date <> pha.end_date))
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/341285/viewspace-1026186/ ，如需转载，请注明出处，否则将追究法律责任。
