3,491
社区成员
发帖
与我相关
我的任务
分享
select t1.org_alias,t2.stats_name,t.complete_val,t.years,t.months,t.plan_val,t.predict_val,t.advise_val,t.remarks
from pd_t_stats_data t, pd_t_org_config t1, pd_t_dict_stats t2
where t.org_id = t1.org_id
and t.STATS_id = t2.stats_id
and t.RPT_ID = 'SJB_S02'
and t.org_id = '22143'
and t.years = '2012'
and t.months = '11'
for update
select t1.org_alias,t2.stats_name,t.complete_val,t.years,t.months,t.plan_val,t.predict_val,t.advise_val,t.remarks from pd_t_stats_data t, pd_t_org_config t1, pd_t_dict_stats t2 where t.org_id = t1.org_id and t.STATS_id = t2.stats_id and t.RPT_ID = 'SJB_S02' and t.org_id = '22143' and t.years = '2012' and t.months = '11' for update of t1.org_alias
类似这样,先改t1,再改t2,......