[MonetDB-users] SQL: Update table from another table

Hello All,

Does SQL frontent support updating one table with data from another table ? More formally, if I have two tables

create table t1 (id1 int, val1 varchar(255)); and create table t2 (id2 int, val2 varchar(255)); ,

can I execute statement like this (PostgreSQL syntax):

update t1 set val1=val2 from t2 where id1=id2; ?

Thanks in advance.

-- Best regards, Andrei Martsinchyk mailto:andrei.martsinchyk@gmail.com