请高手们给一个具体点的例子吧
是级联更新的意思吗???
------解决方案--------------------
- SQL code
也可以update aset col=b.numfrom tb a inner join (select col1,sum(col) as num from tb group by col)bon a.col1=b.col1
也可以update aset col=b.numfrom tb a inner join (select col1,sum(col) as num from tb group by col)bon a.col1=b.col1