upate table1 set price=10, sum=10*count
where id in (select id from table1 t, table2 r where t.id=r.parentid and to_date(r.date,'mm')=to_date(sysdate,'mm'))
或者
upate table1 set price=10, sum=10*count
where id in (select id from table1 t, table2 r where t.id=r.parentid)) and to_date(r.date,'mm')=to_date(sysdate,'mm')
根据情况而定
where id in (select id from table1 t, table2 r where t.id=r.parentid and to_date(r.date,'mm')=to_date(sysdate,'mm'))
或者
upate table1 set price=10, sum=10*count
where id in (select id from table1 t, table2 r where t.id=r.parentid)) and to_date(r.date,'mm')=to_date(sysdate,'mm')
根据情况而定
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货