[MonetDB-users] How to update one table from another

Hi, I have two tables: table1 ----------- id data ----------- 0 0 1 1 2 2 ----------- table2 ----------- id data ----------- 2 2 3 3 ----------- I need to increment data in big table1 by data from small table2 if it exists or insert absent data from table2 to table1. So result must looks like: table1 ----------- id data ----------- 0 0 1 1 2 4 3 3 ----------- I used loop by table2 rows and inserts or updates table1 in this loop in PostgreSQL. What is the most effective way to do it in MonetDB? -- Thanks, Eugene Prokopiev