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

7 Sep 2005

      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