tmp_max_rate 有记录否,是否和t_order的记录一样这样改下 是下呢update t_order set max_rate=(select a.max_rate from tmp_max_rate awhere a.chkitem=t_order.chkitem)wheremax_rate in (select max_rate from tmp_max_rate )...
显示全部tmp_max_rate 有记录否,是否和t_order的记录一样
这样改下 是下呢
update t_order set max_rate=(select a.max_rate from tmp_max_rate a
where a.chkitem=t_order.chkitem)
where
max_rate in (select max_rate from tmp_max_rate )
收起