update us_quotes_history_11 a join us_quotes_history_11 b on(a.RIC=b.RIC and a.hq_time=date_add(b.hq_time, interval 3 month)) set a.acc_volume=b.acc_volume where a.RIC="IXIC" and a.hq_time > '2013-06-28';
posted on 2013-06-28 16:01 高华 阅读(163) 评论(0) 编辑 收藏 举报