update wx_weather a set (a.high_l,a.low_l)= (select high_l,low_l from wx_original_weather b where a.date_l=b.date_l) where a.date_l in (SELECT date_l from wx_original_weather) 原文链接：https://www.f2er.com/oracle/211908.html