在PLSQL Developer运行下面的语句,提示 ora-00971: missing SET keyword
请高手给下解答.谢谢.update table1 t1, table2 t2, set t1.charge=t1.charge*(t2.re/0.1)
where t1.stype=5
and t1.sub_id=t2.sub_id and t2.re<>'yes';
请高手给下解答.谢谢.update table1 t1, table2 t2, set t1.charge=t1.charge*(t2.re/0.1)
where t1.stype=5
and t1.sub_id=t2.sub_id and t2.re<>'yes';
where t1.stype=5
and t1.sub_id=t2.sub_id and t2.re<>'yes';
update table1 t1 set charge=(select t1.charge*re/0.1 from table2
where sub_id=t1.sub_id and re<>'yes')
where stype=5
where sub_id=t1.sub_id and re <>'yes')
where stype=5
where t2.re<>'yes' and t1.sub_id=t2.sub_id)
where exists (select * from table2 t3 where t1.sub_id=t3.sub_id and t3.re<>'yes')
and t1.stype=5