Hello, On a related note, would it be possible to have a "with" statement inside the subquery, .i.e. "update t1 set data = *(with tmp_table as (select ...) select ... from ... where ...)* where exists (select * from t2 where t1.id= t2.id);"? According to my tests it's not possible. What would be the best way to simulate it in MonetDB? Using a View/Temporary Table? Thank you, George
Thanks for your reply and clarification! With Jan2014 release, the two functions can be expressed in the following working forms: 1) update t1 set data=(select t1.data+t2.data from t2 where t2.id=t1.id) where exists (select * from t2 where t1.id=t2.id); 2) update t1 set data = (select sum(t2.data) from t2 where t2.id=t1.idgroup by t2.id) where exists (select * from t2 where t1.id=t2.id);