Re: sum with update

2007-02-19 Thread ViSolve DB Team
Hi, Yes it is possible to use sum with Update, subject to the constraint -table to be updated must not present in the FROM clause of the select stmt. But in your query, the table to be updated is present in the FROM clause. Hence update doesn't support that and have to go for some proce

sum with update

2007-02-17 Thread Ahmad Al-Twaijiry
Hi Everyone I have a question regarding SUM and Update. is it possible to use SUM with Update ? for example I have 3 tables table_1: idT1 Price 120 230 350 420 table_2: idCust Total