[MonetDB-users] Update using two (2) tables

4 Jul 2008

      Hello,

I am having trouble with the syntax for doing an update using 2 tables.
In postgres, one can do something like:

update table1
  set name = table2.name
  from table2
  where table1.id = table2.id
;

In oracle (it's something like)

update table1 a
   set name = (select b.name from table2 b
               where a.id = b.id)
;

What is the correct way to do this in MonetDb (as both of the above fail)

Thanks,
Kirk.

[MonetDB-users] Update using two (2) tables

Kirk Abbott