34,590
社区成员
发帖
与我相关
我的任务
分享
update t_calculateTemp t1 set t1.FAmount_PER = t1.famount/t2.ftotal from t_capacity t2,t1 where t1.FYear=t2.fyear and t1.FPeriod=t2.fperiod and t1.FFactory=t2.FFactory
update t1 set t1.FAmount_PER = t1.famount/t2.ftotal
from t_capacity t2,t_calculateTemp t1
where t1.FYear=t2.fyear and t1.FPeriod=t2.fperiod and t1.FFactory=t2.FFactory
update t1
set FAmount_PER = t1.famount/t2.ftotal
from t_capacity t2,
t_calculateTemp t1
where t1.FYear=t2.fyear
and t1.FPeriod=t2.fperiod
and t1.FFactory=t2.FFactory
update t1 set t1.FAmount_PER = t1.famount/t2.ftotal
from t_capacity t2,t_calculateTemp t1
where t1.FYear=t2.fyear and t1.FPeriod=t2.fperiod and t1.FFactory=t2.FFactory
update t1
set t1.FAmount_PER = t1.famount / t2.ftotal
from t_capacity t2,t_calculateTemp t1
where t1.FYear=t2.fyear and t1.FPeriod=t2.fperiod and t1.FFactory=t2.FFactory